# Converting 100 cents to 1 dollar

1. ## 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

2. Total Dollars
=112+INT(223/100)

Total Cents
=MOD(223,100)

You could replace the numbers with your formulae

Mangesh

3. Thank you sooooooooooooooo mcuh for you help

4. Thank you sooooooooooooooo mcuh for your help

5. ## Re: Converting 100 cents to 1 dollar

Thanks for the feedback.

Mangesh

"Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
>
> Thank you sooooooooooooooo mcuh for your help
>
>
> --
> Jim333
> ------------------------------------------------------------------------
> Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186
>

6. ## Re: Converting 100 cents to 1 dollar

Thanks for the feedback.

Mangesh

"Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
>
> Thank you sooooooooooooooo mcuh for your help
>
>
> --
> Jim333
> ------------------------------------------------------------------------
> Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186
>

7. ## Re: Converting 100 cents to 1 dollar

Thanks for the feedback.

Mangesh

"Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
>
> Thank you sooooooooooooooo mcuh for your help
>
>
> --
> Jim333
> ------------------------------------------------------------------------
> Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186
>

8. ## Re: Converting 100 cents to 1 dollar

Thanks for the feedback.

Mangesh

"Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
>
> Thank you sooooooooooooooo mcuh for your help
>
>
> --
> Jim333
> ------------------------------------------------------------------------
> Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186
>

9. ## Re: Converting 100 cents to 1 dollar

Thanks for the feedback.

Mangesh

"Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
>
> Thank you sooooooooooooooo mcuh for your help
>
>
> --
> Jim333
> ------------------------------------------------------------------------
> Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186
>

10. ## Re: Converting 100 cents to 1 dollar

Thanks for the feedback.

Mangesh

"Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
>
> Thank you sooooooooooooooo mcuh for your help
>
>
> --
> Jim333
> ------------------------------------------------------------------------
> Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186
>

11. ## Re: Converting 100 cents to 1 dollar

Thanks for the feedback.

Mangesh

"Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
>
> Thank you sooooooooooooooo mcuh for your help
>
>
> --
> Jim333
> ------------------------------------------------------------------------
> Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1