On 8 Mar 2007 23:58:02 -0800, "PWS" wrote:

I have a requirement to displace the follwoing pair of data items as
shown:

A simple example is:

2.753, 2.848 ....... 2.75 / 85

I have the following formula:

=TEXT(2.753;"0.00")&" / "&TEXT((2.848-INT(2.848))*100;"00")

Obviously on the workbook the values as cell references

Using the follwoing example I get a 'wrong' result.

2.850 - 2.995 should be shown as 2.85 / 00, but is shown as 2.85 /
100.

I do not understand how 995 becomes 100 rtaher than 00, when the
format requested is "00", but it does.

Can anyone think of a way to achieve what I am looking for?

Try this:

=TEXT(A1,"0.00") &" / "&RIGHT(TEXT(100*(A2-INT(A2)),"00"),2)
--ron