Thread: numbers as text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cj cj is offline
external usenet poster
 
Posts: 9
Default numbers as text

When I type a long number which is really text like 1172532152025 into
an excel cell it displays it as 1.17253E+12. So I go format/cells/text.
It still shows 1.17253E+12. Can I fix this w/o changing what I'm
typing in. IE I can NOT type in '1172532152025.