View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEORGIA
 
Posts: n/a
Default change scientific notation (exponential) back to text

Hi.
I have received a file and some of the customer # has been changed as
scientific notation.

8.50E+281
like so. I went format CellText and it doesn't convert back to text.
I have also tried Text column text and it still remains the same. Is there
a way to restore what it used to be? It's supposed to be 85E280.

THANK YOU!