Thread: Cannot retrieve string data in CSV and Excel files
View Single Post
  #12 (permalink)  
Old July 4th, 2006, 09:11 AM
g000we g000we is offline
Registered User
  
Join Date: Jun 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to g000we Send a message via Yahoo to g000we
Default
If anyone is trying to put a number into a cell of a CSV file with a preceding 0 or zero, then add a preceding "'" character e.g."value1","value2","'001234". Excel grumbles but Customers are happy!

Jesus == Way == Truth == Life == Love == God
Reply With Quote