Date Format Question

  • Thread starter Thread starter vitality
  • Start date Start date
V

vitality

Hi! everyone.

I hv one Excel date format question.

The excel show the date as follows:
5/9/2017 0:00:00 (under the format of d/m/yyyy h:mm)
This is definitely is a wrong date.

When I change the format to GENERAL, it show like this
42983

Anyone can help me to change to the correct date?

Thank you very much
 
So what it is supposed to be? Excel year zero is Jan 0 1900 and each day
after that is added so today would be 38743 (days after Jan 0 1900) that
gives that the number (42983) you are formatting as a date according to
excel is in fact Sep 5 2017, what did you put there in the first place and
what did you expect it to be?

--
Regards,

Peo Sjoblom

Portland, Oregon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access General Date Forced To Have Date And Time 2
convert date/time to just time 4
date format convert 2
How to enter start and end date/time in excel based on some specific value. 7
cannot change date format 4
Converting european date format to US format. 2
Default date format 4
Getting MM-DD HH:MM out of Julian date 4

Back
Top