Hi,

Probably best to do this the other way round. First, select your column
and format it so that the numbers are rounded to two decimal places:
Format Cells Number Number

Once this is done, in an empty cell type 10, then copy this. Select
your column again and do: Edit Paste Special Divide

That should sort it.

HTH,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=560580