Auto formatting

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I periodically need to type part numbers into a cell. If
the number I type in can be interpreted as a date, Excel
will automatically change it to a date format. How do I
turn this annoying feature off? I cannot even go into
formatting and change the cell back to a general format
without it erasing what I have put in that cell and
replacing it with its "sample". Any help someone could
give me on this would be greatly appreciated. To respond
to my e-mail you must remove the "xx". Thanks,

Jim
 
Jim

Format the cells (or whole column, even) as text before you start typing.

Andy.
 
Hi
format the cell (prior to entering something) as 'Text' or enter a
leading apostrophe '
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting in Excel 2010 2
Excel Macro to automatically go to the right of the last colored cell 0
enable/disable auto-convert a NUMBER to DATE 4
Auto Cell Format Change from General to Custom Date 1
How to remove the automatic date format? 3
Auto date in excell 2010 4
Remove date format? 3
Format date in a cell 2

Back
Top