View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roney Roney is offline
external usenet poster
 
Posts: 1
Default "General" format default

Hello. I need to have a rather unskilled person import CSV data repeatedly
into excel. Some of the data is numeric in form (e.g 000123 or 089.00) but I
want it treated as text so that it is imported exactly as presented. Other
than having the person manually select the "text" option for each column
every time (which is fraught with peril), is there a way to do this? Can I
change the import default format from "General" to "text"?

Thank You

Roney Pate