View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 17
Default Stop Excel From Formating Text Starting with A Zero

This is driving me nuts!

I have a script that dumps a text file into Excel. The text file
contains some data such as the following.

Name Rev State Last First
Date
06700332 2 330 Clysdale Ron 11/20/2006 21:59

What happens though in Excel is that the 06700332 is changed to
6700332 automatically. I can't get it to stop it. I've tried
formating the column as text with no luck. Perpaps there is something
that I can programatically stick in the front of the zero to tell
Excel it's not a number. I don't know.

Can you help?
Andy