say your data is
1.25
25
0.75

and these are calculated by "your formula"

if(yourformula-int(yourformula)=0,yourformula,100*yourformula)

this tests for a whole number and leaves it as it is, otherwise
multiplies by 100

It won't work for one decimal place but that doesn't matter.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=529140