Hi,

I have a row of values as follows with maximum upto 10 values in eac
row:

<--- 5 values --- some other colummns <--- 5 values ---
12 34 21 17 90 76 6
51 33 21 21 34

I would like to compute a number out of these values as follows:
1. integer part of the number is maximum of all the values in a row
2. decimal part of the number is concatenation of all the remainin
values

I am relatively new to excel. I am not sure how to get it to work.
want the final number to be calculated automatically whenever th
numbers in any of the cells change.

I appreciate all your help.

Thank you.

Yusu

--
Message posted from http://www.ExcelForum.com