| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding Leading Zeros to Text
In column A I have text like the following
1.2 01.34 03.4 2.1 What I need excel to do is look in Column A and any text that does not begin with a zero character, add a zero to the beginning of the text string, else leave it alone. So that my above example when done would look like: 01.2 01.34 03.4 02.1 Any quick fixes for this? I have a thousand rows so doing this by hand would really stink! Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells, using text as number | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
| numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
| Adding a text label to a line. | Charts and Charting in Excel | |||
Threaded Mode
