Guideline #14: Pay Attention to Units and Number Formats
Yes, we love writing about spreadsheets. We, Infotron and the Delft University of Technology, write articles about creating good reliable spreadsheets every other week. Never miss one!
Pay Attention to Units and Number Formats
Excel horror stories are often related to accidentally changing, shifting or changing units or number formats. Where Americans think in dollars, Europeans might think in euros. Large organizations think in thousands, small organizations might calculate in cents. And the English have their own units for everything. Read more
On perfectxl.com you can Subscribe on our guidelines for free.
Webwinkel
7 年I have a problem with Excel changing numbers in general format changing to accounting format. For example you have a list of numbers, like debtornumbers and when you reopen the file all numbers are in USD dollars. You can change it back to numbers, save it, but the next time you reopen the numbers are again in USD dollars. It happens in mutiple files, with multiple people, but not in every file. I understand the IT department did report it to microsoft, but there is no resolution yet .