Ask Your Question

calc does not show the correct - date format ? [closed]

asked 2013-02-19 16:50:11 +0100

xfighter9 gravatar image

updated 2013-10-08 22:36:00 +0100

manj_k gravatar image

Please help me ? sent from Visual Basic 6 show the wrong dates, examples of 12/10/2013 = calc '12/10/2013 not date format. not see the date format. How fix ?

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-10-22 16:41:30.051179


Try to send in another format, such as 2013-12-10 (yyyy-mm-dd) or formatted date column in calc before sending.

B.Horvat gravatar imageB.Horvat ( 2013-02-20 07:55:46 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-02-19 21:31:13 +0100

horst gravatar image

updated 2013-02-19 21:34:20 +0100

You entered the date as text ("'" at the beginning and it is probably left-aligned). Edit the cell (F2) and delete the "'" at the beginning. Then right-click on the cell and select "Format Cell", under "Number" you can select then the date format you want.

The date format shown in your example is the standart US format Month/Day/Year shown in formatting window as MM/DD/YYYY.

edit flag offensive delete link more

Question Tools


Asked: 2013-02-19 16:50:11 +0100

Seen: 1,060 times

Last updated: Feb 19 '13