Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prefixing a number to the number in a cell
I have in column A, 1000 numbers, now i need to prefix an identical number to
all the 1000 numbers in A column. What is the easiest way?. I want the number to be prefixed in the same A column.. Pls help Regards Sherees -- Life isa journey not a destination |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prefixing a number to the number in a cell
Hi Sherees,
Try this, as I don't believe you can do this with a formula. Sub PrefixItsSelf() Dim cell As Range For Each cell In Selection cell.Value = cell.Value & cell.Value Next End Sub Copy into the sheet module and select the cells you want to prefix and then run the macro. HTH Regards, Howard "Sherees" wrote in message ... I have in column A, 1000 numbers, now i need to prefix an identical number to all the 1000 numbers in A column. What is the easiest way?. I want the number to be prefixed in the same A column.. Pls help Regards Sherees -- Life isa journey not a destination |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prefixing a number to the number in a cell
Hi,
The answer depends on what you want to do with this prefixed number if it's purely for show then apply a custom format of (say) "99999"&# Now any number will have the prefix of 99999 If that doesn't do it for you then post back Mike "Sherees" wrote: I have in column A, 1000 numbers, now i need to prefix an identical number to all the 1000 numbers in A column. What is the easiest way?. I want the number to be prefixed in the same A column.. Pls help Regards Sherees -- Life isa journey not a destination |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions |