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

Sinan621

Copper Contributor

Feb 04, 2021

Mike_Honey Thanks for sharing, I have applied you formatting proposal to a number column, then numbers just "disappear", when I remove the formatting the numbers are visible again but not formatted as desired. Maybe this is applicable for "calculated columns" only?

Mike_Honey

Brass Contributor

Feb 05, 2021

Sinan621 - my tests so far are regular number columns, so it can work. Sorry it didn't work for you. .displayValue is mentioned on this page:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

If I find out more I'll post back here.

Mike_Honey
Brass Contributor
Apr 21, 2021
Hiker10 - did you try my example above? It should work in your scenario.
Hiker10
Copper Contributor
Mar 27, 2021
Mike_Honey

I have a calculated column of dollar amounts. In the data type returned from this formula, I've selected currency. How can I have my column, right align, with $ sign, and thousands commas, stay in tact? I have chosen 0 decimal points.

Thank you!