We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

calc: how to copy a date format in a text string [closed]

asked 2013-08-29 17:48:04 +0200

HaPK gravatar image

updated 2021-05-27 13:38:17 +0200

Alex Kemp gravatar image

Sorry if the question is not so clear. I have a spreadsheet with some cells formatted as date and time, but I need to copy those dates and times as are shown in a text string, not the raw numerical, and weird, format that calc transforms them when in the text string.

I think I'm making the wrong formula. This is the link of the spreadsheet, I think you can understand it better if you see it (see the second sheet).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-07 11:08:12.905209

1 Answer

Sort by » oldest newest most voted

answered 2013-08-29 20:07:01 +0200

w_whalley gravatar image

Where you want your values in cell D2 use the TEXT function instead of the cell references. E.g. for the date instead of C2 use TEXT(C2,"yyyy-mm-dd") and instead of B2 use TEXT(B2,"hh:mm:ss")

edit flag offensive delete link more


That's it, it solved my problem. Thanks a lot!

HaPK gravatar imageHaPK ( 2013-08-30 04:08:42 +0200 )edit

Question Tools

1 follower


Asked: 2013-08-29 17:48:04 +0200

Seen: 22,827 times

Last updated: Aug 29 '13