Date Change

  • Thread starter Thread starter SVanN
  • Start date Start date
S

SVanN

I have entered a date e.g. 9/10/03, and Excel changes it to 37874. I have
tried to format the cell (Format/Format Cells/Number/Date/3/14/98), but it
continues to convert it to 37874. Any suggestions on what to do to correct
this?
 
With the cell blank, format it to General. Then type in the date. HTH
Otto
 
Otto,
I tried but there is no difference. I really don't get it. Got any
idea what else could be controlling the formatting?
SVan
 
Does it show the date ok in the formula bar?

If yes, maybe you have formulas showing.

Tools|options|View|uncheck formulas
 
You may have Formulas set to visible. To change this setting,

1. Choose Tools>Options
2. Select the View tab
3. Under Window options, remove the check mark from Formulas
4. Click OK

The keyboard shortcut is Ctrl + ` (accent grave, left of the 1 key)
 
Dave,
Yes it did show ok in the formula bar. I have finally fixed it. Thanks
for helping!
SVanN
 
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

cannot change date format 4
How to enter start and end date/time in excel based on some specific value. 7
Conditional format Column based on Week Date 2
Date Conversion in Excel 2007 4
date format convert 2
Problem formatting dates from CSV file 2
Converting a date to number 3
Date formatting 4

Back
Top