formatting text box linked to excel cell


I have a text box linked to a cell.  The cell is formatted as currency with no decimals. The text box is not formatted as currency and goes 4 place after the decimal.  

How do I get the text box to be formatted as currency with no decimal places?

Thank you.
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

EirmanConnect With a Mentor Chief Operations ManagerCommented:
Is this what you are looking for?
A2 is an intermediate cell that you can hide.
Katie PierceCommented:
Your best best might be to create a second cell that reads =ROUND(J3,2)

(J3 is the cell I used as your 4 decimal place value to test this out.)

This will give you a 2 decimal place value that you can then link your text box to.
jverasqlAuthor Commented:
I am trying to format as currency with no decimal places.
All Courses

From novice to tech pro — start learning today.