Home |
Search |
Today's Posts |
#1
|
|||
|
|||
date format
When I enter a date format 04/09/05, Excel displays 01/00 in the cell. Why is
it doing this. I have gone to format cells and formated the cell for dates, 03/14. Any suggestions? Thanks... |
#2
|
|||
|
|||
Sounds like you have Lotus 123 transitions set:
ToolsOptionsTransition Tab Uncheck the 2 sheet options. Does that help? Regards, Ron |
#3
|
|||
|
|||
Go to toolsoptionstranstion and uncheck
transition formula entry using that you are actually doing =4/9/5 which is 0.0888888888888889 and since it is less than a day it will be 02:00 AM jan 0 1900 thus the result Regards, Peo Sjoblom "Mark" wrote: When I enter a date format 04/09/05, Excel displays 01/00 in the cell. Why is it doing this. I have gone to format cells and formated the cell for dates, 03/14. Any suggestions? Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |