Numbers is stuck on Automatic formatting -- nothing is working
Hi, I downloaded a CSV doc into Numbers of my transactions and it includes Australian dollar currency figures eg. A$5.50. I need to add these long lists of A$ figures but Numbers is only recognising them as "Text". When I try to change the format to currency or number by the usual ways, it just reverts back to "Automatic". Nothing I've tried seems to work. Have tried "Clear all" and pasting with matching style etc. Have tried pasting in a new sheet, nothing, nada.
It's vexing. Very grateful if anyone who knows how to fix this can speak up.
Cheers,
Ian
MacBook Air 13″, 10.14