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

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