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
 
Back
Top