How to calc a column of formulas?

  • Thread starter Thread starter Bill in Verona, WI
  • Start date Start date
B

Bill in Verona, WI

IF J5=11, K5=12, L5=P, then

=+J5&":"&K5&" "&L5 shows 11:12p. If I do F2, F9 (edit, calc, enter), it
shows 11:12 PM. How do you calc the same formula in several cells at the
same time (non-vba)? Copy (a range), paste special, values apparently is
not the same as edit, calc, enter.

Thanks
 
Bill

Try formatting cells as Time.

Then copy an empty cell. Select your range of cells then Paste
Special>Add>Ok>Esc.

Gord Dibben Excel MVP XL2002
 
Gord, thank you! Bill


Gord Dibben said:
Bill

Try formatting cells as Time.

Then copy an empty cell. Select your range of cells then Paste
Special>Add>Ok>Esc.

Gord Dibben Excel MVP XL2002
Click to expand...
 
Back
Top