Hello all,
I have a spreadsheet that I’ve formatted a column to Currency in Euros, but for some unknown reason many cells don’t have the € sign, while others in the column do. What can I do to ensure they all match?
About the cells which don’t abide by the currency formatting:
How were data entered there? Does the entry procedure differ from what happened in the “conforming” cells?
Was it e.g. …
- By manual entry?
- Did the entry contain anything other than +/- sign, digits and decimal sign (like thousands separators or dashes)?
- By copy/paste from other spreadsheet cell?
- By import from external data file?
1 Like
It’s a fresh spreadsheet, and I’ve only clicked into the cell, typed the number, and hit Enter to go to the line below. Same procedure for the rest of the column. It’s really strange this is happening. I’m not copying/pasting at all. Want to fix this abnormality before the spreadsheet grows.
Since your file is not yet very large, it makes sense to reduce the file to the point where the problem is still present. And anonymize the file if necessary.
Then upload the file here so that someone can look at it. Thank you.
1 Like
The numbers which do not receive proper format, are entered as text. Most likely reason is that you are using comma as decimal separator but entered numbers with a period. That makes the entry an invalid number, which automatically converts to text.
Enter numbers again, using proper decimal separator.
1 Like
You were right on point. In The Netherlands, they use commas for currency separation (i.e. €500,00). Every time I put a decimal in (a relic from my days in the US), the formatting broke. Thank you! As soon as I changed the decimals to commas, it worked. Thanks again!
1 Like