Convert Cents to Dollar/Cents

[kennedymr2]

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]

hi,

simple quotient with divisor of 10[sup]2[/sup]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

Or - in simple term:
[tt]
1323 / 100 = 13.23[/tt]

Have fun.

---- Andy

 

[SkipVought]

Aw

http://www Andy.

Do you give the answers to your kids?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

Skip - I don't have any kids

And since it did not look like a school homework assignment, ...

Have fun.

---- Andy

 

[SkipVought]

3[sup]rd[/sup] grade, if i recall.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kennedymr2]

1323 / 100 = 13.23

Gee i must be getting old or demented.. thanks

 

[Golom]

Just to be really pedantic

1323 / 100 = 13 [red]==> Integer arithemetic[/red]

1323. / 100 = 13.23 [red]==> Floating Point[/red]

 

[jizzer]

Except integer division uses the backslash ...
1323\100 = 13
1323/100 = 13.23

 

[tedsmith]

Print Format(x/100,"$.##") where x is the cents to be converted

 

[Unscruffed]

To expand on Ted's reply:

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

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!