| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop text from disappearing when I wrap text in Excel? | Excel Worksheet Functions | |||
| How can I stop Excel from formating my infromation as a Date? | Excel Discussion (Misc queries) | |||
| Stop Outlook from starting when typing email addresses into a cell | Excel Discussion (Misc queries) | |||
| loop question trying to bring excel into autocad text not starting in correct place | Excel Programming | |||
| Stop autoloading a New worksheet when starting Excel | Setting up and Configuration of Excel | |||
Threaded Mode
