Forum Discussion
In Microsoft Excel I would like to format cells for date as 10-10-2010 instead of 10/10/2010
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?
- 10/10/2010 is a bad example - it doesn't tell us whether you want month-day-year or day-month-year. Anyway, you can assign the custom number format mm\-dd\-yyyy or dd\-mm\-yyyy to the cells with the dates. But I would prefer to use an unambiguous date format such as d-mmm-yyyy or yyyy-mm-dd.
- You can store the info in worksheets in a single workbook. Save that workbook to a cloud service such as OneDrive, Google Drive or Dropbox and share it with your family members.