Format 000000 if you want 6 digits.

If you want to keep the number of digits you had in the input, and this is
variable, then you'll need to keep as text, rather than converting to
numbers.
--
David Biddulph

"Debi" wrote in message
...
When using the special paste option of multiply in order to change all
cell
to a number format after using the right, ltft, or mid fuctioin how do I
keep
the leeding zeros?