enter only numbers and have them formatted as $99.34

  • Thread starter Thread starter knowledge seeker
  • Start date Start date
K

knowledge seeker

I want to enter in Access or Excel 9999 and have it formated as $99.99. How
can I set this up?
 
On Tue, 28 Apr 2009 09:40:05 -0700, knowledge seeker <knowledge
I want to enter in Access or Excel 9999 and have it formated as $99.99. How
can I set this up?
Click to expand...

Set the Format property of the field to Currency and the Input Mask to
"999,999.00".
 
Shudup!!!


On Tue, 28 Apr 2009 09:40:05 -0700, knowledge seeker <knowledge


Set the Format property of the field to Currency and the Input Mask to
"999,999.00".
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif with 2 criteria 4
Incrementing PART NUMBER on form 4
Do not round percentage 1
Microsoft Excel 2003 9
Importing Data From Excel Spreadsheet 3
Populating Fields 1
Changing Date Format? 4
How to Export Gmail Emails to PST Format? 4

Back
Top