Jan 16 2020 07:53 PM
Hi Everyone,
I have created various sharepoint lists that represent master chart of accounts for our financial systems general ledger codes. I have set up number columns to represent a unique code attributable to an item (e.g. 2001 would be assigned to Interest Revenue etc). However, but using a number column the code defaults to appear as "2,001".
There is no way to remove the comma without effectively converting either the column or the data to a text field. Using a text field is not an option I want to pursue, as when the data is exported to an excel table, excel doesn't pick up the data as a number. So when trying to apply a formula like vlookup, it will not be able to read the data from that column.
Thanks
Jan 20 2020 05:12 PM
SolutionHi @Kruchiver,
You can submit requests via the SharePoint User Voice. There are a number of submissions requesting the same.
I hope this helps.
Norm
Jan 20 2020 05:17 PM
@Norman Young Great. Thank you
Jan 20 2020 05:12 PM
SolutionHi @Kruchiver,
You can submit requests via the SharePoint User Voice. There are a number of submissions requesting the same.
I hope this helps.
Norm