122024-07-18 07:15:44kputyr112024-07-18 06:34:08alrutz102024-07-18 06:22:13kputyr92024-07-17 11:47:11alrutz82024-07-17 11:43:42alrutz72024-07-17 11:42:36alrutz62024-07-17 11:40:05alrutz52024-07-17 11:39:55alrutz42024-07-17 11:38:17alrutz32024-07-17 11:33:42alrutzRenamed from 'https:/wiki.math.uzh.ch/public/Office365/Excel'.22024-07-17 11:32:49alrutzRenamed from 'Excel'.12024-07-17 11:32:01alrutz

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: Format all the cells before inserting numbers (select either "standard" or "number"): /home/b/alrutz/Desktop/3.png /home/b/alrutz/Desktop/4.png 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" /home/b/alrutz/Desktop/5.png /home/b/alrutz/Desktop/6.png /home/b/alrutz/Desktop/7.png