Hi Brian,

I tried the following in some cells.

cell A1: 456.79 (2 decimals)
cell A2: 321.54 (2 decimals)

then in cell B1, i putted the following formula, which returns the first 3
characters beginning from the right): =RIGHT(A1,3)
B2: =RIGHT(A2,3)
B4, i putted the total: = B1+B2

I tried to use the sum() statement, but (strangely) this doesnt work

Hope this helps

Regards
Max Potters


"BrianG" wrote in message
...
I'm working on a template form where I would like to be able to sum a
column then post the whole number portion of the sum to one cell and the
decimal portion of the sum to another cell. How could this be
accomplished?

BrianG



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!