Despite formatting a column in Excel 2002 worksheet as Short Date.

P

Pete Whalley

Having created a column formatted as a date in a 2002 Excel spreadsheet the
column a figure which seems to be the number of days from a date in 1900. It
is recognised as a date in both the formula bar at the head of the
spreadsheet and when the cursor is moved over the field.
I have looked at all the options but cannot see anything that will change
this.
Can you please help
Pete
 
D

Dave Peterson

It sounds like you toggled the formula view (nice for debugging worksheet
formulas).

Tools|options|View tab|uncheck formulas.
 
P

Pete Whalley

Thanks for that - you hit the nail on the head!!!
I can now hand this over to my users with a clear conscience.

Pete
 
Top