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

Duh!

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