| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leading Zero and the change command
My data is preceeded by "." up to "........" When I use the change command to
delete the ".", it also drops any leading zeros in the text. The field is formatted as text and the data is not proceeded by a single quote. Ex. ...01263 changes to 1263. Any ideas why this would happen? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the face color of an Excel command button | Excel Discussion (Misc queries) | |||
| How do I change font colour in an if command? | Excel Worksheet Functions | |||
| CHANGE DATA SERIES WITH A COMMAND BUTTON | Charts and Charting in Excel | |||
| Change Name of Command Button | Excel Discussion (Misc queries) | |||
| use replace command to change the contents of formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
