formatting a field to currency without the $ symbol

[Guest_imported]

A silly one!
im trying to format a field in one of my tables to a general number with two decimal places. Basically i want it to be the same as the currency field but with no $ symbol. Ive tried using general number etc but the field isn't getting rounded off to two decimal places and when the number has no decimal places the number isnt inserting the cents part eg 129 should become 129.00 im just wondering how i would format a field to display data like this.

 

[MichaelJ]

Go to the design view of the table and select the number field you are referring to and on the general tab at the bottom change format to standard and decimal places to 2.

Mike

 

[Guest_imported]

Thanks MichaelJ
Thats exactly what i needed.