View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
maryj maryj is offline
external usenet poster
 
Posts: 76
Default exponential notation

I have a product number 00E1 - Excel always wants to display it as 0.00E+00.
I can get it to display as I want if I format the cell as text. However, I
then need to save it as a csv file and then it changes back to 0.00E+00. Any
suggestions how to keep the format as text rather than converting it back to
a number?
--
maryj