Formatting Question

[maxxximaniac]

Hey Everyone,

I have a number field of a check amount excluding the decimal point.
Example 50000
Check amount is actually 500.00

Is there a way to insert a decimal point before the last two numbers?
This is for a mass file, so an automated process would be delightful.

Got my VPs breathin down my neck, gotta love corporate world.

I would greatly appreciate any help I can get,
Thanks in advanced!

 

[maxmangion]

you can try it this way:

Format([FieldName]/100,"0000.00")

 

[maxxximaniac]

works like a charm, thanks fellas