Navigation
Recherche
|
How Do I Enter a Date In Numbers Using Dot (.) As the Separator?
jeudi 9 septembre 2021, 15:30 , par MacMost
How to enter a date using period or dot (.) as the separator; and using yyyy.mm.dd as the entry format? My system preferences short date format is set up as yyyy.mm.dd. Numbers will recognize “-” and “/”. I do not care to use those for data entry.
Example: Typing 2021.9.2 into a date cell should be accepted as a date that I might format as 2021 Sep 2. I do not usually format dates with dots, but it is my preferred method of data entry on a numeric key pad; and it is the way I have done it in Excel for years. —– Bob T
https://macmost.com/forum-how-do-i-enter-a-date-in-numbers-using-dot-as-the-separator.html
|
59 sources (15 en français)
Date Actuelle
ven. 26 avril - 13:06 CEST
|