Thread: Unable to pre-format cells to text when exporting data to csv or x
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Big P The Big P is offline
external usenet poster
  
Posts: 2
Default Unable to pre-format cells to text when exporting data to csv or x
I frequently have to export data from an ERP to excel. I can export as csv or
txt and have to manually intervene to change xecel cell format to text so
that the leading zero's aren't lost. I want to automate this process. How (if
at all) can excel be pre-formatted to always open in text format to prevent
the leading zero's been lost?
Reply With QuoteReply With Quote