howdo I turn off default that automatically changes 8-4 to Aug-4?

D

Don

When I type 8-4 or 8/4 in a cell, these characters automatically change to
Aug-4 when I move to the next cell. Obviously there is a default at work in
Excel 2003 that is doing this. Is there a way to turn off this default or am
I forced to contiually text format the cells into which I type characters
such as these?
 
C

CLR

Type an apostrophe before the 8, or pre-format the cell as TEXT

Vaya con Dios,
Chuck, CABGx3
 
I

Intekhab Aalam

You can set the locale option to English (United States) instead of
letting it be custom.
(e-mail address removed)
 

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

Problem with MS Word paragraph and character styles: format getting messed up 2
Turning off the month function 3
CSV->Excel Data Problem 1
Date mm/yy 2
turn off automatic date default 2
Change Default Auto-Fill-In month 5
Excel does not accept text format! 0
How do I install Microsoft Equation 3.0 back to Office 365? 0

Top