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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
It sounds like you toggled the formula view (nice for debugging worksheet
formulas).

Tools|options|View tab|uncheck formulas.
 
Thanks for that - you hit the nail on the head!!!
I can now hand this over to my users with a clear conscience.

Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Columns formatted As Dates Are Exported as a Number to Text 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Dates in Excel 2007 5
Dates before 1900 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Remove date format? 3
Excel Excel due and overdue date colours 2
Date Format - Conversion 1

Back
Top