Comma and point
Hello,
i got a few columns (text/Number), Column abcd .
Column F is the total of all the others.
All columns are with $ sign
if i'm adding an amount with a point it's fine the amount got the $ sign and it's adding to F column.
But a coworker is using the same ( point) but the amount is not add to F column, neither the $ sign. If she's using a comma it's working.
How can i make it the same for every one to make sure the amount are adding for everybody?
thank you
have a good one :)
Answers

You can set the column properties to currency, but when the data is entered in a non number format the dollar sign wont be added to the cell as the sheet doesn't recognise it as a number
Unfortunately this is one of the cases where you will need to ask your colleague to be more careful when entering the data into cells.
Making sure that they use . instead of , and I would guess that the cell with 500.32 in has a ' in front of the number ('500.32) so the cell is being read as text not a number.
Hope that helps
Thanks
Paul McGuinness

Hello Paul ,
Everybody wants to use the ''. '' , more easy on the keyboard.
But some people actually need to use the coma to get the $ sign and amount count, and other need to use the point. This is where my real problem is.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!