Jul 15 2022 08:25 PM
I'm doing a family directory. I save each family's info separately. How can I save it all in one file to be shared with eveybody?
Jul 18 2022 06:55 AM
Jul 18 2022 09:13 AM
As a comment. Dates in Excel are actually sequential numbers starting from 1 which is equal to Jan 01, 1900 (if you are on Windows). Applied date format is only shows these date in human friendly form. If you are in US and add date as 07/18/2022, your relative in UK who opens the same file, will see the date as 18/07/2022.
Thus don't care about formatting, use your default one. However, if you enter the date as the text, e.g. 07-18-2022, people in other regions will see it as the same text and they need to convert such text into the date in accordance with their regional format.
However, if you enter the date as text which is only looks like date, e.g. "07-18-2022", it'll be no such transformation. To check, by default text is left aligned and date is right aligned in the cell.