How do you add a "$" to my field that is code...

[Tina_Cheng]

How do you add a “$” to my field that is coded as “Number”? I’ve added $ to my original data file, but can’t seem to get the dollar sign to show up.

Is there a different format to use?

[Stephen_Mattiso]

Probably need to set it as a Price column. You can then go into that column attributes and change it to how many decimal points you want to see.

[Tina_Cheng]

@Stephen_Mattison Thank you!

[Stephen_Mattiso]

@Tina_Cheng Welcome!

Usually if you set

up your column in your Sheet as Currency, AS will pick that up and set your Column to Price, sometimes it doesn’t get it just the way you want, probably my fault, haha!.

Occasionally, I need to go into the Column Definition and set my Decimals to zero.