Help needed seperating a value

[noodnutt]

G'day guy's

here's the deal, I need to discect a number as such:

$2392.43: A1=2392 - A2=.43

Now I have use Left() which gives me 2392, BUT!
when I use Right(), I get a whole number 4255 instead of
..43.............(very frustrating).

the purpose for this I hear you ask, well, I need to seperate the cents of
the whole number, calculate the tax payable, then add back the cents that
was removed, fun, isn't it...............(Not)

Any assistance is appreciated

TIA

Mark.

 

[Philip Reece-Heal]

Try putting in A1 INT($2392.43) and in A2 MOD($2392.43).
Alternatively put $2392.43 in A1 and in cell A2 put formula INT(A1) and in
A3 put formula MOD(A1)

All the best
Philip

 

[Philip Reece-Heal]

Sorry but error in last line of my reply; Formula in A3 should be MOD(A1,1)

Regards
Philip