Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MyHeartPoursOn
 
Posts: n/a
Default How do I stop Excel 2002 from autoformatting numbers into dates?

When I type in a number such as "3/8" or "3-8", Excel automatically changes
it to "08-Mar". I've tried changing the format of the cell to general, but
that changes the data to say "38149" and then changes back to custom
formatting when I attempt to type in "3/8" again. I've tried turning off all
autoformatting and autocorrecting. All this technology of "guessing" what
you're trying to type can be extremely frustrating and pointless when you
can't even type basic data into the worksheet.
  #2   Report Post  
Mike
 
Posts: n/a
Default

Change the cells to plain text.

"MyHeartPoursOn" wrote:

When I type in a number such as "3/8" or "3-8", Excel automatically changes
it to "08-Mar". I've tried changing the format of the cell to general, but
that changes the data to say "38149" and then changes back to custom
formatting when I attempt to type in "3/8" again. I've tried turning off all
autoformatting and autocorrecting. All this technology of "guessing" what
you're trying to type can be extremely frustrating and pointless when you
can't even type basic data into the worksheet.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Add-in: Open Database Connectivity available for Excel Nick B Excel Discussion (Misc queries) 8 December 7th 06 06:04 PM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
hyperlinks not working in excel 2002 SP3 Roundy Excel Discussion (Misc queries) 0 July 7th 05 09:40 PM
How to stop Excel from automatically selecting cells? geekgirl33 Excel Discussion (Misc queries) 1 July 5th 05 11:50 PM
Excel 2003 formats different that excel 2002 Rich Excel Discussion (Misc queries) 0 April 22nd 05 05:43 PM


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"