Date converts to numerical

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

Guest

I have a cell that I formatted for date. But everytime i put a date in the
block, it convert to a numerical number. For example 3-24-2007 converts
always to 39165, 3-23-2007 converts to 391164, 3-12-2007 converts to 39153.
Sorta seems like it is counting. Help!!!
 
David,
I forgot to tell that. If I select any format of the date entry, it
converts still to the numerical format. Also if you look in the fx line it
shows the correct date entry. I think I changed a option somewhere..
 
Gord, I read the Chip Pearson page but my problem is the excel cells on the
entire worksheet will not change to date. I can enter anything on the page as
a date and it pops back to the numberical date. Is there a option to disble
this without haveing to type a function for date every time I want o put a
date or general entry in a cell? I tried the deleting the whole column but
the error is the entire sheet.
 
Do you see the date in the formula bar?

If yes, you may be looking at formulas.

Tools|Options|view|uncheck Formulas.

ctrl-backquote (ctrl-`) is the shortcut key to toggle this setting. You may
have hit that in error.
 
Excel is changing the format to General for some reason.

Do you have any worksheet event that is running?

Is it just the one worksheet or any worksheet?

Just the existing workbook or any new workbook?

Right-click on the sheet tab and "View Code". Anything in there that looks like
it might be doing the deed?

If the entire workbook check in this spot............right-click on the Excel
Icon left of "File" on the menu bar. Select "View Code".

Anything in there?


Gord
 
Duh!

Way too simple<g>


Gord

Do you see the date in the formula bar?

If yes, you may be looking at formulas.

Tools|Options|view|uncheck Formulas.

ctrl-backquote (ctrl-`) is the shortcut key to toggle this setting. You may
have hit that in error.
Click to expand...
 
Back
Top