Format for Text and Currency excel 2003

[pedro-egoli]

I want to show a $ amount in cell G2 which will display Credit $209.80.

The figure of $209.80 is present balance however, this will change from month to month.
It will always be a Credit figure and will be the figure shown in C30.

Have tried

="Credit " &C30

However it comes out without the currency symbol and is to 4 decimal places rather than the two I need.

What will show "Credit $209.80"?

Thanks

Pedro

 

[VoG]

Try

="Credit "&DOLLAR(C30,2)

 

[Yahya]

Try this

="Credit " &TEXT(C30,"$#0.00")

 

[pedro-egoli]

Thanks Vog and Yahya they both work.

Much appreciated.

Pedro

 

[Yahya]

Thanks Vog and Yahya they both work.

Much appreciated.

Pedro

you are welcome