Need textbox to be formatted as Currency

Hi.

I am trying to make a recipe costing spreadsheet and I want a textbox to display the price of the recipe.

I linked the textbox to a cell that has a formula that links from another sheet. I want the formula calculation to show up in the textbox, formatted as currency.

I am uploading a sample.

Thanks!

Originally Posted by 6StringJazzer

A textbox contains text, so you can't directly apply numeric formatting. Fortunately you are getting the value from a cell so you can convert the cell to text. Change the formula in M7 to this:

Formula:

Please Login or Register  to view this content.

Wonderful! Thanks so much!