How do I stop excel from auto formula, ie 48E69 makes 48.0e+70?

M

metaylor

I am making a list of general numbers and excel keeps making a formula out of
anything with an E in it, example 48E69 turns into 48.0E+70. I can't figure
out how to stop this from happening and I have about 100 parts with an E in
them.
Help someone!
Thanks,
 
N

Nick Hodge

Pre-format the cells as text or pre-fix the entry with a leading apostrophe
'. It will stop this and won't show

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

Trevor Shuttleworth

Format the cells as text or put a single quote (') in front of the "number"
before you enter it.

Regards

Trevor
 

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

Help with lots of formulas 3
Automatically populate value of cell dependent on adajecent cell 3
How do i stop Excel from turning a value into a formula? 4
Excel keeps auto-changing my formulas to include other cells. 2
Formula for looking up and copying from another worksheet? 1
If Formula and Dates 4
Creating Labels Over 3-Up Image 2
Inserting Lines Makes Formula Inactive 7

Top