If I paste a bank statement into a blank sheet, all the numbers which have a decimal point become locked as Automatic under Data Format and can not be changed to Number or Currency. However the numbers pasted without a decimal point can be changed to anything.
This was never a problem with my previous Numbers program and was all very simple. Any advice or help?
MacBook Air 13″, macOS 11.3
Sometimes this sort of thing can occur if the bank is providing data that uses the . as a decimal separator whereas your machine and Numbers are set to a region that expects , as a decimal separator. Or vice versa.
Perhaps you could provide more details on what region your machine is set to.
Note that in Numbers you can now "switch regions" by going to File > Advanced > Language & Region ...
SG
Sometimes this sort of thing can occur if the bank is providing data that uses the . as a decimal separator whereas your machine and Numbers are set to a region that expects , as a decimal separator. Or vice versa.
Perhaps you could provide more details on what region your machine is set to.
Note that in Numbers you can now "switch regions" by going to File > Advanced > Language & Region ...
SG
Yes, I see South Africa uses , as a decimal separator. At File > Advanced try switching Language & Region to say, US, paste the the data, and then you should be able to switch back to South Africa.
SG
Hi SG
Thank you for your response - my machine region is set to South Africa.
I'll try switching region as see if that helps with "." issue.
cheers Warrick
Hi SG
I have done as you've suggested and it works - thank you very much.
Warm regards Warrick
Numbers
