software

Hi all,

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

When I change it back to 'General' formatgt;cellsgt;number the cell changes
to quot;38725quot; .

How do I turn off the automatic date format, so that my cell will just
contatain quot;01/08/2006quot; 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:
gt; Hi all,
gt;
gt; I need help! When I type this: quot;01/08/2006quot; into the cell it
gt; automatically changes into date format: quot;1/8/2006quot;.
gt;
gt; When I change it back to 'General' formatgt;cellsgt;number the cell
gt; changes
gt; to quot;38725quot; .
gt;
gt; How do I turn off the automatic date format, so that my cell will just
gt; contatain quot;01/08/2006quot; without changing to the date format????
gt;
gt; Thanks--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: 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:
gt; Hi all,
gt;
gt; I need help! When I type this: quot;01/08/2006quot; into the cell it
gt; automatically changes into date format: quot;1/8/2006quot;.
gt;
gt; When I change it back to 'General' formatgt;cellsgt;number the cell
gt; changes
gt; to quot;38725quot; .
gt;
gt; How do I turn off the automatic date format, so that my cell will just
gt; contatain quot;01/08/2006quot; without changing to the date format????
gt;
gt; Thanks--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=537399You 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:
gt;
gt; Hi all,
gt;
gt; I need help! When I type this: quot;01/08/2006quot; into the cell it
gt; automatically changes into date format: quot;1/8/2006quot;.
gt;
gt; When I change it back to 'General' formatgt;cellsgt;number the cell changes
gt; to quot;38725quot; .
gt;
gt; How do I turn off the automatic date format, so that my cell will just
gt; contatain quot;01/08/2006quot; without changing to the date format????
gt;
gt; Thanks

--

Dave Peterson