Thread
:
In excel how do i get from this 44345678912 to this 0345678912 us.
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
In excel how do i get from this 44345678912 to this 0345678912 us.
Formula
="0"&RIGHT(C4,LEN(C4)-2)
macro
sub fixnums()
for each c in range("a2:a22")
c.value="0"&"&RIGHT(C,LEN(C)-2)
next c
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Twoways" wrote in message
...
I have in column A list of numbers looking like this 44345678912 and i need
to place a zero in front of the number but also taking away the two fours,
i
know the formula for adding the zero ="0" & [A1] but can anyone help with
removing the two fours or a quick way to doing one at a time?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett