View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jim swanson jim swanson is offline
external usenet poster
 
Posts: 1
Default How to prevent General format from using scientific notation?

The default is to display any number of ovver 12 digits as sci-not which can
truncate precision and causes problems with exports and other uses.

Is there a way to defeat this behaviour. I, personally, would preffer
treating it as text, but a simple long integer would be fine, too.