Hi.

I am wanting to know hbow I would go about getting the following 3
cells:

Cells A1, A2, A3:
::
1-4,6,8 50 S1B1::

Into a form that looks more like this
::A1 A2 A3
1 8.33 S1B1
2 8.33 S1B1
3 8.33 S1B1
4 8.33 S1B1
6 8.33 S1B1
8 8.35 S1B1::

How it does the rounding (and on which one), it does not matter!

Thanks,
Tom


--
tomjermy
------------------------------------------------------------------------
tomjermy's Profile: http://www.excelforum.com/member.php...o&userid=24666
View this thread: http://www.excelforum.com/showthread...hreadid=382414