Thread: How do I stop excel from auto formula, ie 48E69 makes 48.0e+70?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default How do I stop excel from auto formula, ie 48E69 makes 48.0e+70?
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
DTHIS
www.nickhodge.co.uk


"metaylor" wrote in message
...
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,


Reply With QuoteReply With Quote