I have a date in my workbook of 39335 which I know should be 09/10/2007
How do I get the 39335 to look as it should?
Thanks!
Dave
I have a date in my workbook of 39335 which I know should be 09/10/2007
How do I get the 39335 to look as it should?
Thanks!
Dave
Format as dd/mm/yy
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
This, for some reason, causes the date to become 10/09/2007. However formatting it as MM/DD/YYYY caused it to look like it should - 09/10/2007.Originally Posted by VBA Noob
Its working, but unsure why?
Thanks though!
Excel stores dates as numbers starting with 01/01/1900 which equals 1 so 39335 equals 10th Sept 2007.
Link explains more
http://www.cpearson.com/excel/datetime.htm#SerialDates
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks