Do you always have 3 digits in front of the decimal? Is so this might work,
=(A1-(LEFT(A1,3)))*100/32

(If there are more or less than 3 digits in front of the decimals this
formula will not work.)

"Solarissf" wrote:


hopefully someone can help me out with this, driving me nuts
If I have a number:

106.05

I want to divide whatever is after the decimal by 32.

In the above example
106.05
I want to take (5/32) = .15625

another example
106.10
(10/32) = .3125

Anyone know a formula to do this???

Thanks in advance


--
Solarissf
------------------------------------------------------------------------
Solarissf's Profile: http://www.excelforum.com/member.php...o&userid=34834
View this thread: http://www.excelforum.com/showthread...hreadid=553246