Thread: Prevent conversion of numeric text string to scientific notation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
  
Posts: 1,090
Default Prevent conversion of numeric text string to scientific notation
Increase the width of the column as needed. HTH Otto
"StuckWithExcelAlas" wrote in
message ...
If i type, paste, edit in situ, or text-to-column large numeric string
like:
0342737749549075
it will be converted to
3.42738E+14
completely against my will. The Cell is set as 'text'
(What part of 'text' does Excel not understand??)
I'm on Mac, so that could also be the problem.


Reply With QuoteReply With Quote