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

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

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

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