Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

GoneOffShore

(17,341 posts)
Fri May 17, 2019, 04:35 AM May 2019

Problem with 'Numbers'

I'm trying to formulate a spread sheet in Numbers(IOS version) on my MacBookPro - When I type in the amounts, they are formatted as text and I can't get the columns to sum up. I've tried selecting all and formatting as currency and as numbers. Even when I format individual cells they revert back to text as soon as I type something in the cell.
It's just a very simple sheet tracking expenditures over the year for my accountant.
Any clues? I've used Numbers before and haven't had this problem.

2 replies = new reply since forum marked as read
Highlight: NoneDon't highlight anything 5 newestHighlight 5 most recent replies
Problem with 'Numbers' (Original Post) GoneOffShore May 2019 OP
And I solved the problem. My region was set incorrectly and commas were substituted for decimals GoneOffShore May 2019 #1
Thanks for sharing the fix. TexasProgresive May 2019 #2
Latest Discussions»Culture Forums»Apple Users»Problem with 'Numbers'