Quick formatting questions - using Excel

How to change table content from values to “text”? Both tables formats provided seem only to pull numbers and then cells populated with text shows on the table as a question mark “?”. How to populate the table with text?
Second quick question, how to indicate the currency format within a text box. Here are two images.
Thank you in advance for the HTML code and where to place it.

Column
Currency

Hi Linda,

Unfortunately, the data table only accepts numerical values.

You can format values inside of text with a converter

{{ Cost_of_Materials_per_investment_type__per_key_  | $0,000 }}

will display

$150,000

Hi Will, Thank you for answering so quickly. Here is another question then regarding Data Tables and text. Is it possible to code such that a number is converted to text inside the table? In other words, I could use the number 1 for “Construction”. So when the table pulls up “1”, the number is coded to publish in the table the word “Construction”. I notice that you mention something for returning colors in the tables, is there something that could be done with specific words being exchanged for numbers?

Thank you in advance, L