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
|