keep leading zeros when using the paste spec. multiply function

D

Debi

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?
 
D

David Biddulph

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.
 
D

David Biddulph

In which situations will that work, Dave?

The only version where I could see something keeping its leading zeroes was
when I multiplied a cell which was already a number formatted with enough
digits for a leading zero, but the OP was using the paste special/ multiply
process to change cells to number format when they started as text (from
RIGHT, LEFT, or MID), and in that situation I'm confused as to how your
suggested process will retain the leading zeroes?
 
Top