Excel

Issues

Excel is configured to recognize dates and change the formatting of a cell automatically, whenever it recognizes a date.
Sometimes the recognition is faulty, which results in cells being formatted as dates, even though it is just a number.
There are two approaches to fix the issue:
1. Format all the cells before inserting numbers (select either "standard" or "number"):
2. Change decimal & thousands separator (regional settings):
  - Click File > Options
  - On the Advanced tab, under Editing options, clear the "Use system separators" check box
  - Type new separators in the "Decimal separator" and "Thousands separator boxes"

-  ⇤ ← Revision 9 as of 2024-07-17 11:47:11 → 
  Size: 25
  Editor: alrutz
  Comment:
+   ← Revision 10 as of 2024-07-18 06:22:13 → ⇥
  Size: 1023
  Editor: kputyr
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
+<<TableOfContents>>
-Line 3:
+Line 5:
- <<Tree>>
+== Issues ==

=== Numbers are unwillingly converted to dates ===

 * Excel is configured to recognize dates and change the formatting of a cell automatically, whenever it recognizes a date.
 * Sometimes the recognition is faulty, which results in cells being formatted as dates, even though it is just a number.
 * There are two approaches to fix the issue:
   1. Format all the cells before inserting numbers (select either "standard" or "number"):
   {{attachment:/home/b/alrutz/Desktop/3.png}}
   {{attachment:/home/b/alrutz/Desktop/4.png}}
   1. Change decimal & thousands separator (regional settings):
     * Click File > Options
     * On the Advanced tab, under Editing options, clear the "Use system separators" check box
     * Type new separators in the "Decimal separator" and "Thousands separator boxes"
       {{attachment:/home/b/alrutz/Desktop/5.png}}
       {{attachment:/home/b/alrutz/Desktop/6.png}}
       {{attachment:/home/b/alrutz/Desktop/7.png}}