| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a 0 in front of a column of numbers
Hello All
I need a script to add a 0 infront of a column of numbers that are in text format. Thanks Scott |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a 0 in front of a column of numbers
Sub addzero()
For r = 1 To 100 Cells(r, "A").Value = "0" & Cells(r, "A").Value Next r End Sub -- Ian -- "scasawyer" wrote in message ... Hello All I need a script to add a 0 infront of a column of numbers that are in text format. Thanks Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I markup a column of numbers without adding a column? | Excel Worksheet Functions | |||
| Adding a zero to the front of numbers | Excel Worksheet Functions | |||
| need help in adding a ' in front of a column of numbers | New Users to Excel | |||
| adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
| adding digits to front/end of fax numbers | Excel Discussion (Misc queries) | |||
Linear Mode
