How to calc a column of formulas?

[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

 

[Gord Dibben]

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

 

[Bill in Verona, WI]

Gord, thank you! Bill

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