Cell format - how to disable auto date

  • Thread starter Thread starter KH_GS
  • Start date Start date
K

KH_GS

I want the cell to be "3 - 5" but it auto changes it to "5-Mar".

How do I stop that from happening besides using '3-5 ?
 
Only way is to either precede each entry with an apostrophe ' (it's not
visible in the cell) or to pre-format as text

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
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

Auto fill not working 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Prevent auto date format 3
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Auto filter question 1
The next Grand Theft Auto title has been officially announced 0
Excel Help with dates 2
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5

Back
Top