Why not use TEXT(A1,"000000"), for example?
--
David Biddulph

"gary" wrote in message
...
Since the number of digits varies, is there a way to automatically add
zeroes between the single quote and the first significant digit of the
number so the result has the correct number of characters?