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

S

shrut

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?
 
T

Tom Collins

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
 
Top