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?

After you do the copy
Edit|paste special|check Values and then multiply.

Debi wrote:

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?

--

Dave Peterson

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?
--
David Biddulph

"Dave Peterson" wrote in message
...
After you do the copy
Edit|paste special|check Values and then multiply.

Debi wrote:

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?

--

Dave Peterson

You're right. I read the OP's message incorrectly.

David Biddulph wrote:

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?
--
David Biddulph

"Dave Peterson" wrote in message
...
After you do the copy
Edit|paste special|check Values and then multiply.

Debi wrote:

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?

--

Dave Peterson

--

Dave Peterson

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?