Autoformatting?

G

Guest

How can I keep excel from changing cell-entered numbers, 04-9215 for example,
into dates? I've tried selecting "none" for autoformatting on entire
worksheet.
 
G

Guest

Yeah, I should have said I also tried "General" to no luck. "Text" fixed the
problem. Thank you.
 

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

Date 2
Excel autoformatting dates 1
How to stop automatic cell shading 3
How do I stop Excel 2002 from autoformatting numbers into dates? 1
stop creating email link when @ sign is present 2
numbers to dates 9
Unwanted formatting of time data 2
Need to add apostrophe to beginning of cell 2

Top