if you already have a list of numbers stored and dont want to reenter all of
them

if numbers are in cell A1 , in cell c1, ="0"&a1

then copy the formula down to put your ) back in place

format cells c as text first


"duckie" wrote:

On Sep 24, 8:57 pm, duckie wrote:
i loose the zero infront of phone numbers how do i get it back

thanks for the help