Paste Special Multiply Changing Number Format to One Decimal

[Jeffrey Mahoney]

When I use the Multiply feature of paste special, Excel converts the number format to one decimal. I confirmed that the number format was 2 decimals before.

Is it doing that for you? Excel WHY!!!!

 

[DanteAmor]

Select Paste Values, Otherwise it will paste the format of the source cell.

 

[Jeffrey Mahoney]

Hi Dante. Your right, I would need to format the cell I copied with the same format as the destination. I was just thinking that they separated those functions because we're not really pasting values. I made a simple routine and added it to my QAT.

Sub MultiplyCells()
  Dim mVal As Double
  Dim Cel As Range
  
  mVal = Val(CopyFromClipboard)
  
  On Error Resume Next
  For Each Cel In Selection
    Cel.Value = Cel.Value * mVal
  Next Cel
  
End Sub