| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Box lost its leading 0 - need help
The strangest thing happened ... for the longest time my macro worked
well. One textbox queries a lot number which starts with a 0. The target field is formatted as text: Range("Z2:Z3").NumberFormat = "@" All of a sudden the box removes leading zeros... Cant figure out why .... the code realting to this hasnt changed. How can I force the box to be text and leave leadign zeros alone? Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading zeros lost in csv | Excel Worksheet Functions | |||
| text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
![Matt[_33_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
