Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

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

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Programmers > Languages > Visual Basic(Microsoft): Version 5 & 6 Forum

Convert Cents to Dollar/Cents

thread222-1665008
Read More Threads Like This One
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  say

1323    to   13.23

Regards  kennedymr2


 
SkipVought (Programmer)
27 Oct 11 20:54


hi,

simple quotient with divisor of 102

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Andrzejek (Programmer)
27 Oct 11 21:21
   
Or - in simple term:

1323 / 100 = 13.23  smile

Have fun.

---- Andy

SkipVought (Programmer)
27 Oct 11 21:24


Awwww Andy.  Do you give the answers to your kids?

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Andrzejek (Programmer)
28 Oct 11 8:28
   
Skip - I don't have any kids  smile

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,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

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 pedantic

1323 / 100 = 13      ==> Integer arithemetic

1323. / 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

To expand on Ted's reply:

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!

Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Visual Basic(Microsoft): Version 5 & 6

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close