Hi Barry,
It was a valid point you made and I have been trying many things all day, spurred on by your suggestion.
The numbers entered just aligned to the left and no matter what I did to reformat everything, it just reverted back to the multiple option instead of the number option I was after and the value was not recognised. I did test it on currency and a Euro sign popped in there. That should have given me a clue yesterday. (It did not and in my defence I was tired and been at this for two weeks)
I tried to make a brand new sheet so it would not get contaminated as I had a lot of tabs on the last one. That did not work either. When I was trying to input some figures in the thousands, that is when the light bulb went off.
It showed up a 6 000,00 and that is the European way of doing things. This has never happened before and I have been lugging my laptop around Italy, England and France for years.
Anyway, as I am in Toulouse at the moment all I can think of is there may have been an update over the last couple of months although I am not aware as I do not have it on automatic update.
Still, if I remember it is a comma and not a point between the dollars and cents and I will be just fine. I thank you for your suggestion which gave me encouragement and I don't have to take up my husband's offer of Excel.
Merry Christmas to you and stay safe out there
Thanking you again
Elaine
