Formatting help required...

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

Guest

I am working on Excell 2003 and I have applied a format to a cell, I can see
the formatting in the formula cell but when I hit return the cell will not
update to the format applied.
ie. Formatting for a date, I have applied the format to the cell and the
formula toolbar shows the information in the correct format say 02/05/2007
but when I press return the cell shows 39203 while the formula toolbar is
still showing 02/05/2007.
Can anyone help with the above error as it is part the excel shet is part of
a report that I need to issue.
John
 
The 39203 indicates that the format is General, (where it should be Date).
Have you tried formatting the cell to Date, hit the return button to move
out of the cell, then click back in the cell, enter the date and return again?
BCB
 
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

Excel VBA 1
formula displays as a formula, not as its result 1
Finding dates without attention to data formats 1
conditional formatting update issue 5
Excel Named Ranges and Conditional Format 3
Date Format 1
Spurious Formula Omits Adjacent Cells 2
Refusing to Date Format 1

Back
Top