how do i stop the auto format on excel?

G

Guest

I am trying to enter the value 1-5 in a cell it and keeps auto changing into
the date! how do i stop this?
 
N

Nick Hodge

James

Pre-format the cell as text (Format>Cells...Text) or prefix with a single
apostrophe '. It won't show but will stop the conversion

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
D

David Biddulph

James said:
I am trying to enter the value 1-5 in a cell it and keeps auto changing
into
the date! how do i stop this?
Click to expand...

Format the cell as text before you enter the value. The alternative is to
precede the value with an apostrophe.
 

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

How to stop the auto-format of dates? 5
How to STOP Excel from changing my data 1
Auto Correct 3
Auto fill not working 2
date format 2
Stop XL from changing format? 1
Cannot get date to format correctly 1
The next Grand Theft Auto title has been officially announced 0

Top