HomeLatest ThreadsGreatest ThreadsForums & GroupsMy SubscriptionsMy Posts
DU Home » Latest Threads » Forums & Groups » Topics » Computers & Internet » Apple Users (Group) » Problem with 'Numbers'

Fri May 17, 2019, 04:35 AM

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, 406 views

Reply to this thread

Back to top Alert abuse

Always highlight: 10 newest replies | Replies posted after I mark a forum
Replies to this discussion thread
Arrow 2 replies Author Time Post
Reply Problem with 'Numbers' (Original post)
GoneOffShore May 2019 OP
GoneOffShore May 2019 #1
TexasProgresive May 2019 #2

Response to GoneOffShore (Original post)

Fri May 17, 2019, 04:53 AM

1. And I solved the problem. My region was set incorrectly and commas were substituted for decimals


Reply to this post

Back to top Alert abuse Link here Permalink

Response to GoneOffShore (Reply #1)

Fri May 17, 2019, 08:03 AM

2. Thanks for sharing the fix.

Reply to this post

Back to top Alert abuse Link here Permalink

Reply to this thread