You need to sign in to do that
Don't have an account?

Need to hide commas on a Numeric Field
I have a numeric field for Fiscal Year End (so, the data looks like 2007, 2008, 2009, etc). But, when the data appears on list views, it shows as 2,007, 2,008, 2,009 (with commas). How can I configure this to not show the commas?
Thanks,
Joanna
Thanks,
Joanna
Since the numeric data you're storing is a year rather than numeric data that you'd need to perform mathematical calculations on, use a text field or a picklist field. The commas won't appear in those field types.

TA_Invisible is right on target. Also, since the years are all 4 digits (at least for the length of my career), they will still sort properly.

Thanks. I switched this to a text field.