Forum Discussion

Copper Contributor

Mar 02, 2020

Solved

Sharepoint Online, number column NOT aligned right

Hello, i have a sharepoint online custom list with number column(s) with decimals and thousands separator. As far as I understand, numbers should be aligned right by default? However in my c...

SharePoint Online

FabioO365GoD
Mar 04, 2020
Sinan621

Yes, you need to replace the formula:
=TEXT([Column],"###,###.00")

This type of modification doesn’t have any impact on the original column

Thanks

Copper Contributor

Mar 04, 2020

Again, many thanks for taking time to help me with my question. I tried it and it is very close. The only missing part is now the thousand separator: Is that possible?

And will I be still able to make number calculations with this type of column?

Cheers

Sinan

Brass Contributor

Mar 04, 2020

Yes, you need to replace the formula:

=TEXT([Column],"###,###.00")

This type of modification doesn’t have any impact on the original column

Thanks

Sinan621
Copper Contributor
Mar 04, 2020
FabioO365GoD

You rock! It works, many many thanks 🙂

For the benefit of all, here comes a summary of the steps:

- create a new calculated column with this formula: =TEXT([Column],"###,###.00")
- format this new calculated column with:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"style": {
"display": "table",
"width": "100%"
},
"children": [
{
"elmType": "div",
"txtContent": "@currentField",
"style": {
"display": "table-cell",
"text-align": "right",
"vertical-align": "middle"
}
}
]
}
- markikav
  Copper Contributor
  Jul 09, 2020
  Sinan621
  This is great information but does it mean that the user has to enter the value in one column and then we use this calculated column to present the data right aligned?
  So then the users would have to be aware of this if making any edits afterwards?
  
  When I created a new column called "Amount" and entered the formula =TEXT([Amount],"###,###.00")
  I get an error saying the column doesn't exist?
  
  Thanks!
  - FabioO365GoD
    Brass Contributor
    Jul 15, 2020
    markikav
    Would you mind sending the screenshot showing the formula that you insert and the errors that you get?
    
    Thanks

Resources