| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dates 01/1/02005 comes u ps as 0.011111111
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
|
|||
|
|||
|
Discounting the typo, maybe you have a Lotus 123 setting enabled.
Tools|Options|Transition Tab Uncheck Transition Formula Entry (I unchecked all those Lotus 123 settings.) DateConfused wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
| 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) | |||
Linear Mode
