| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change #'s to Text macro
I need to be able to do the following:
I have a list of store #'s in column D (ex below). I need to format the column as text and for any number that is less than 10, I need it to be changed so that it has a leading 0 that will stay when saved as a CSV file. I'm stuck on this so any help would be great. Thanks Current How I want it 1 01 2 02 3 03 4 04 5 05 6 06 7 07 8 08 9 09 10 10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change cell text color | Excel Discussion (Misc queries) | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
| macro to change text to time | Excel Worksheet Functions | |||
| How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
| HOW TO CHANGE BAHTTEXT (THAI TEXT) TO ENGLISH TEXT IN EXCEL | Excel Worksheet Functions | |||
Threaded Mode
