Entering dates for computation purposes

[alonzo3]

1. When I enter ="1/1/1995" on a NEW worksheet,I get a numerical answer as expected.
2. When I enter the same info on an EXISTING
worksheet,I get the date and cannot get EXCEL to recognize it as a number.
3. How can I correct this situation?

Thanks ... Al Nasitano

 

[Dave Hawley]

Hi

Probably you have the cells formatted as Text, use any date format.

Or you can easily convert by copying a number 0 from any cell, selecting the dates and going to Edit>Paste Special | Add then format as dates

 

[Al Chara]

Try it without the quotation marks.

Hope this helps.
Kind regards, Al.

 

[Dave Hawley]

Good point!


alonzo3, are you sure you were getting a real number on a new worksheet using

="1/1/1995"

???

 

[Mark W.]

On 2002-03-15 07:34, alonzo3 wrote:
1. When I enter ="1/1/1995" on a NEW worksheet,I get a numerical answer as expected.
2. When I enter the same info on an EXISTING
worksheet,I get the date and cannot get EXCEL to recognize it as a number.
3. How can I correct this situation?

Thanks ... Al Nasitano

Enter ="1/1/1995"+0 instead.