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
|