| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text Box lost its leading 0 - need help
Problem corrected: Not sure how but I forced the leading zero in there
;) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text Box lost its leading 0 - need help
In any event, you can use the text property of the range to display the
value as displayed msgbox ActiveCell.Text rather than msgbox ActiveCell.Value -- Regards, Tom Ogilvy "Matt" wrote in message oups.com... Problem corrected: Not sure how but I forced the leading zero in there ;) |
| Reply |
| 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)
Hybrid Mode
