Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When I format for dates in a column I get this bogus number. How can I fix it
so the column reads the date entries????? Thank you |
#2
![]() |
|||
|
|||
![]()
umm
01/1/02005 isn't a date - any reason you have the extra 0 in before the 2005? if this was a typo in your post then could you give us a couple of examples of your dates, let us know how you entered them and how you're trying to format them. Cheers JulieD "DateConfused" wrote in message ... When I format for dates in a column I get this bogus number. How can I fix it so the column reads the date entries????? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dates 01/1/02005 comes u ps as 0.011111111 | Excel Discussion (Misc queries) | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) |