View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter[_28_] Peter[_28_] is offline
external usenet poster
 
Posts: 60
Default How to add a leading zero

On Mon, 21 May 2007 21:25:38 +0100, Peter
wrote:

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?


Thanks to all that were kind enough to reply - your formatting
suggestion worked perfectly - exactly what I wanted!
--
Cheers

Peter

Please remove the invalid to reply