location: Diff for "Office365/Excel"

Institute of Mathematics - PublicMathWiki:

Differences between revisions 10 and 11
⇤ ← Revision 10 as of 2024-07-18 06:22:13 →
Size: 1023
Editor: kputyr
Comment:
← Revision 11 as of 2024-07-18 06:34:08 → ⇥
Size: 0
Editor: alrutz
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
<<TableOfContents>>

= Excel =

== 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}}

PublicMathWiki: Office365/Excel (last edited 2024-07-18 07:15:44 by kputyr)