View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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