Convert number formatted as currency to text including the $, com.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to concatenate text with a number formated as currency. However,
it doesn't show the currency indicator, commas, or decimal. How can I
convert the number to text and retain this information?
 
shrut said:
I am trying to concatenate text with a number formated as currency. However,
it doesn't show the currency indicator, commas, or decimal. How can I
convert the number to text and retain this information?
Click to expand...

Use the Format function. There's lots of built-in formats as well allowing
you to customize your own.
Format(1234,"Currency") will give you $1,234.00
Format(12,"0000") will give you 0012

The help file will explain all the options to you.

Tom Collins
 

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Format Currency as Accounting 2
Currency Decimals 5
Number Format 2
convert text typed into a prompt box to number 3
amount field not showing currency format 3
Currency changes when merging to Word 2
VBA to insert currency 3

Back
Top