If A1 hold a value such as $123.45
in B1 enter =INT(A1) and in C1 enter =MOD(A1,1)
now $ and ¢ are separate
Does this answer question?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ncbuilder01"
wrote in message
...

I need to replicate an Accounts Sheet that shows the In/Out cloumns with
dollars and cents in separate columns. How do I set up Excel to SUM
dollars and cents in two separate columns and use two separate columns
for other formulas? - Thanks.


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile:
http://www.excelforum.com/member.php...o&userid=27732
View this thread: http://www.excelforum.com/showthread...hreadid=472431