View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Barnes Bob Barnes is offline
external usenet poster
 
Posts: 134
Default Formatting 11001981003213 as text..

11001981003213 is a serial number. I'm an Access Programmer running
automation to Excel. This long serial number, even when formatted as text on
the Auto_Open event, displays as scientific notation.

Is there an Excel setting to ensure it appears as text?

TIA - Bob