column has (-ve and +ve#'s), %'s, and $ amounts

[soniam]

Hello!! hope everyone is doing well!!

I have a value column that has (-ve and +ve#'s), %'s, and $ amounts but everything for now is showing as a number and I would like to convert them appropriately before I can create a visual. Appreciate the help!

[mceleavey]

Hi @soniam ,

can you post some representative data so we can help?

M.

[apathetichell]

two options - you can convert/make a new string column and format as you choose or you can format inside of the table tool. Percentages work fine there - getting your negative numbers exactly as you want can be problematic. I usually go the string route and keep it as a separate column so if I need to do any conditional value-based formatting I can do it on the nondisplayed original numeric column...