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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
prefix a column of numbers with combination of zeros
Use custom format. 00#. any number entered in the column will be
preceded by two 00 pinny wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
prefix a column of numbers with combination of zeros
Use custom format. 00#. any number entered in the column will be
preceded by two 00 pinny wrote: 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. |
Reply |
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 |