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

Format it back to date (and choose a format to suit).
--
David Biddulph

"Airchief" wrote in message
...
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!!!

Format back to date.

The numbers you see are Excel's serial date number.

For an explanation of how Excel stores Dates see Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben MS Excel MVP

On Sun, 18 Mar 2007 13:00:08 -0700, Airchief
wrote:

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


"David Biddulph" wrote:

Format it back to date (and choose a format to suit).
--
David Biddulph

"Airchief" wrote in message
...
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!!!

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.

"Gord Dibben" wrote:

Format back to date.

The numbers you see are Excel's serial date number.

For an explanation of how Excel stores Dates see Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben MS Excel MVP

On Sun, 18 Mar 2007 13:00:08 -0700, Airchief
wrote:

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

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.

Airchief wrote:

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

--

Dave Peterson

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

On Sun, 18 Mar 2007 13:24:05 -0700, Airchief
wrote:


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.

"Gord Dibben" wrote:

Format back to date.

The numbers you see are Excel's serial date number.

For an explanation of how Excel stores Dates see Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben MS Excel MVP

On Sun, 18 Mar 2007 13:00:08 -0700, Airchief
wrote:

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

Duh!

Way too simple<g


Gord

On Sun, 18 Mar 2007 15:32:15 -0500, Dave Peterson
wrote:

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.

Airchief wrote:

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

I hope it was the right answer!

<hehe



Gord Dibben wrote:

Duh!

Way too simple<g

Gord

On Sun, 18 Mar 2007 15:32:15 -0500, Dave Peterson
wrote:

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.

Airchief wrote:

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

--

Dave Peterson