Thread: How to add a leading zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How to add a leading zero
Use Format Cell | Custom format such as 000000000000000 (as many as are
needed)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Peter" wrote in message
...
Hi

I have a column of numbers - (telephone numbers actually) and I need
to add a leading zero to each one.

Is there an easy way of doing this other than converting each number
to text and adding the leading zero manually?

--
Cheers

Peter

Please remove the invalid to reply


Reply With QuoteReply With Quote