Thread: How to save a 15 digit # in CSV without it changing to a formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AB AB is offline
external usenet poster
  
Posts: 33
Default How to save a 15 digit # in CSV without it changing to a formula?
I have to save my excel sheet as a CSV, but the numbers I am using are 15
digits long and need to be kept that way. Every time I re-open the document
15 digit numbers are all changed to formulas, no matter how I format the
cell. Is there a way to do what I want or is that not compatable with CSV
format.
Reply With QuoteReply With Quote