MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
date
Search

How Do I Enter a Date In Numbers Using Dot (.) As the Separator?

Thursday September 9, 2021. 03:30 PM , from 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
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Mar, Thu 28 - 11:00 CET