Unable to change calc number formats

All was fine until a few weeks ago and then cell formatting of numbers stopped working. Happens on both old and new spreadsheets. I download my bank statement data in CSV format and open that in Calc. I then want to change the numbers into Currency format, but cannot. Today I downloaded and installed the latest version of LibreOffice but the problem still occurs. Any ideas?

See answer to similar question: specify decimal separator in text import

Add Answer is reserved for solutions. Click edit below your question if you want to add more information.