consider 1.25 as a number

convert it to text =1.25

do a global search for the decimal point, replacing it with nothing =125

OR embed this in your formula


A1 = B1 / C1 B1=5 C1 = 4 therefore A1=1.25


A1=text((B1/C1),"0.00") = 1.25

A1=left(text((B1/C1),"0.00"),1) & right(text((B1/C1),"0.00"),2)

this only w0rks if all numbers are to 2 decimal places,you can make it universal by testing for where the decimal point is within the text string.

Why do you need to do this? eople may have a better idea for you.