Smart questions
Smart people
 Find A ForumFind An Expert
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Remember Me

Are you a
Computer / IT professional?
Join Tek-Tips now!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Just copy and paste the

#### Feedback

"Because of this forum, I continue to WOW! my clients!"

#### Geography

Where in the world do Tek-Tips members come from?

# Convert Cents to Dollar/Cents

 Forum Search FAQs Links Jobs Whitepapers MVPs
 kennedymr2 (Programmer) 27 Oct 11 17:51
 Sorry for such a simple question..  i must be betting old. ??Is there a "simple" function to convert  say1323    to   13.23Regards  kennedymr2
 SkipVought (Programmer) 27 Oct 11 20:54
 hi,simple quotient with divisor of 102 Skip,Just traded in my old subtlety...for a NUANCE!
 Andrzejek (Programmer) 27 Oct 11 21:21
 Or - in simple term:1323 / 100 = 13.23   Have fun.---- Andy
 SkipVought (Programmer) 27 Oct 11 21:24
 Awwww Andy.  Do you give the answers to your kids? Skip,Just traded in my old subtlety...for a NUANCE!
 Andrzejek (Programmer) 28 Oct 11 8:28
 Skip - I don't have any kids  And since it did not look like a school homework assignment, ... Have fun.---- Andy
 SkipVought (Programmer) 28 Oct 11 8:50
 3rd grade, if i recall. Skip,Just traded in my old subtlety...for a NUANCE!
 kennedymr2 (Programmer) 29 Oct 11 3:31
 1323 / 100 = 13.23    Gee i must be getting old or demented..  thanks
 Golom (Programmer) 5 Nov 11 15:57
 Just to be really pedantic1323 / 100 = 13      ==> Integer arithemetic1323. / 100 = 13.23  ==> Floating Point
 jizzer (Instructor) 8 Nov 11 9:28
 Except integer division uses the backslash ...1323\100 = 13 1323/100 = 13.23
 tedsmith (Programmer) 13 Nov 11 18:00
 Print Format(x/100,"\$.##") where x is the cents to be converted
 Unscruffed (Programmer) 15 Nov 11 20:05

Format(x / 100, "\$ #,##0.00")

#### CODE

0        becomes \$ 0.00
12       becomes \$ 0.12
1234     becomes \$ 12.34
123456   becomes \$ 1,234.56

and so on.

Heaven doesn't want me, and Hell's afraid I'll take over!

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!