Date converts to numerical

A

Airchief

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!!!
 
A

Airchief

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..
 
A

Airchief

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.
 
D

Dave Peterson

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.
 
G

Gord Dibben

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
 
G

Gord Dibben

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...
 
Top