keep leading zeros when using the paste spec. multiply function
 

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?

keep leading zeros when using the paste spec. multiply function
 

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?

keep leading zeros when using the paste spec. multiply function
 

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

keep leading zeros when using the paste spec. multiply function
 

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

keep leading zeros when using the paste spec. multiply function
 

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