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
|