B1 =INT(A1)
B2 =(A1-B1)*100
If negative values possible use TRUNC

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gabe" wrote in message
...
Hello,

I was wondering if there is anyway to split a value from one cell to two
cells?

Currently A1 = 26.25 (integer), Is there a way to split this value to
have
B1 = 26, and B2 = 25?