View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jonnyjd jonnyjd is offline
external usenet poster
 
Posts: 1
Default How do I stop Excel 2007 from using scientific notation?

I need to stop Excel 2007 from changing a location code (38E2) to scientific
notation. This file needs to be in a CSV format. I have formatted the cell
as TEXT and tried using the single quote before the data ('38E2). Each time
i reopen the CSV file, any cell with that same format (xxEx) turns back to
scientific notation. (Ex. 38E2 3.80E03, 42E2 4.20E03, etc)