View Single Post
  #1   Report Post  
Jim333
 
Posts: n/a
Default Converting 100 cents to 1 dollar


Hi everybody,

I have a question and I hope that I find a satisfactor answer for it,

I have two columns the firs one contains numbers represent dollars
and the other one contains numbers represent cents

Let's assume the the total of cents is 223 and the total of dollars is
112,, The formuls I want is to convert the total of cents to 23 and the
total of dollars to 114 ..

I wish that my question is clear for all.


I hope I find the reply ASAP.

Thanx for All


--
Jim333
------------------------------------------------------------------------
Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186
View this thread: http://www.excelforum.com/showthread...hreadid=375528