format text box

F

fishqqq

I have a text box that i wish to combine information in but don't know
how to format it correctly.
I"m trying to combine two fields into one text box

[service]
[charge]

my text box is formatted as follows "=[service]&" "&[charge]"
this works fine but i would like to have the charge stated as a
currency instead of just a number
Currently it views as follows "Freight 200.50"
is there a way to have it view like "Freight $200.50]" ?

thanks
Steve
 
M

Marshall Barton

I have a text box that i wish to combine information in but don't know
how to format it correctly.
I"m trying to combine two fields into one text box

[service]
[charge]

my text box is formatted as follows "=[service]&" "&[charge]"
this works fine but i would like to have the charge stated as a
currency instead of just a number
Currently it views as follows "Freight 200.50"
is there a way to have it view like "Freight $200.50]" ?


To avoid potentially getting the wrong number of decimal
places, you should use the Format function in that kind of
situation:

=service & " " & Format(charge, "Currency")
or
=service & " " & Format(charge, "$0,000.00")
depending on how you want negative values to look.
 

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

Top