I have generated a form that shows money amounts. yet i want two colums
that separates the dollar amount from cents. I have for example colum
*H* as the dollar amount and colum *I* as the cent amounts. Now i have
tried Format Cell to set it up but it doesnt work. for example i tried
the custom format for the dollar amount and it rounds it. and if
there's an amount of 1108.83 the cell will show 1109. so it does not
show the true value amount. i also tried the same approach with the
=RIGHT(H1,2) but with the left and Mid but still didnt work, because i
would have to enter the same amount of caracters each time. as far as
the cents, there is no problems because i did the =RIGHT(H1,2)
function. it will on show the cent amounts.

so is there another way to set it up?
Please yall.... let me know....


--
Joe@excel
------------------------------------------------------------------------
Joe@excel's Profile: http://www.excelforum.com/member.php...o&userid=29016
View this thread: http://www.excelforum.com/showthread...hreadid=487485