How to remove the automatic date format?
 

Hi all,

I need help! When I type this: "01/08/2006" into the cell it
automatically changes into date format: "1/8/2006".

When I change it back to 'General' formatcellsnumber the cell changes
to "38725" .

How do I turn off the automatic date format, so that my cell will just
contatain "01/08/2006" without changing to the date format????

Thanks

How to remove the automatic date format?
 

Select the cell or column, and rightmouse, Format Cells, Dates, and
select an appropriate format.

Hope this helps.

--

Wrote:
Hi all,

I need help! When I type this: "01/08/2006" into the cell it
automatically changes into date format: "1/8/2006".

When I change it back to 'General' formatcellsnumber the cell
changes
to "38725" .

How do I turn off the automatic date format, so that my cell will just
contatain "01/08/2006" without changing to the date format????

Thanks


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537399

How to remove the automatic date format?
 

Select the cell or column, and rightmouse, Format Cells, Dates, and
select an appropriate format.

Hope this helps.

--

Wrote:
Hi all,

I need help! When I type this: "01/08/2006" into the cell it
automatically changes into date format: "1/8/2006".

When I change it back to 'General' formatcellsnumber the cell
changes
to "38725" .

How do I turn off the automatic date format, so that my cell will just
contatain "01/08/2006" without changing to the date format????

Thanks


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537399

How to remove the automatic date format?
 

You could change your windows short date format, too.

Windows start button|Control panel|regional and language settings (winXP)
Regional Options tab
Click on the Customize button
Click on the date tab
change that short date format to mm/dd/yyyy (or what you want)



wrote:

Hi all,

I need help! When I type this: "01/08/2006" into the cell it
automatically changes into date format: "1/8/2006".

When I change it back to 'General' formatcellsnumber the cell changes
to "38725" .

How do I turn off the automatic date format, so that my cell will just
contatain "01/08/2006" without changing to the date format????

Thanks

--

Dave Peterson