Change row-level data types?

[CapnShanty]

I have a table of MetricName, MetricValue.

Some of these metrics are dollars, others are percents. They are all simply stored as numbers. Is there a way to change individual data point data types, or some sort of clever solution?

One "clever" solution I arrived at was text boxes for dollar signs on the tables that I have. I don't know what to do about the percents though.

[PattemManohar]

@CapnShanty Based on my understanding of your scenario, Did you tried having an another table (Symbols) with MetricName and Symbol.... Link this with your main table on MetricName.... then use the Symbol from Symbols table... Kind off like this.....