Home Ask Login Register

Developers Planet

Your answer is one click away!

SarahAlan February 2016

Excel Date and Time format

I am having trouble with datetime format. I used custom format in order to get my data to read as 01/02/2016 05:33:23. But instead it is reading as 42401 05:33:23.

Any ideas on how to get it to work?



Jordan Biddlecombe February 2016

If you are simply wanting to set a range to this format just go into the Format option once the range is highlighted; then select "More Number Formats". At the bottom is a "Custom" option, in the entry box type the following:

dd/mm/yyyy hh:mm:ss

That should be the correct format setting.

Post Status

Asked in February 2016
Viewed 2,306 times
Voted 6
Answered 1 times


Leave an answer

Quote of the day: live life