Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
prefix a column of numbers with combination of zeros
How can I prefix a column of numbers with a combination of zeros? I have used
"find & replace" using the asterisk, but instead of prefixing the number of zeros and the existing string it literally enters the replace input. i.e find 33*, replace 0033*, inputs 0033*. I thought that the asterisk would request the remaining numbers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duplicate numbers in column a and diferent values in b | Excel Worksheet Functions | |||
Sum/average numbers in column A dependant on value in column B | Excel Worksheet Functions | |||
Excel ? Do Not Call Table | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |