

- #Microsoft excel 2016 for mac formats time as decimal not time mac os x#
- #Microsoft excel 2016 for mac formats time as decimal not time windows#
Be persistent and not tied to anything that changes over time or location.

The following are best practices for file naming. Periods are used to identify file formats such as. Some of these symbols are used in operating systems to perform certain tasks, such as to identify folder levels in Microsoft products and Mac operating systems. Punctuation, symbols, or special characters (periods, commas, parentheses, ampersands, asterisks, etc.) should be avoided. This alteration can cause confusion in identifying the actual file name. For example, “File Name.doc” would appear on-line in the URL as “File%20Name.doc” where?. Web environments translate spaces and will render them as “%20”. Appendix B of NARA Bulletin 2015-04 states that spaces aren’t allowed in filenames.

A best practice is to replace spaces in file names with an underline (_) or hyphen (-). Some applications and computer scripts may not recognize spaces or will process your files differently when using spaces. The advantage of non-descriptive names is that there is less chance of repeated or non-unique file names within a data structure. Non-descriptive file names are often created for large scale digitization projects and may employ a digital ID number and numerical sequences to indicate batch or parent-child relationships. Non-descriptive file names are usually system-generated sequential numerical strings, such as a digital ID number and are often linked to metadata stored elsewhere. However, inconsistent application of terms or typos will contribute to indexing and sorting errors. Descriptive file names are useful for small, well-defined projects with existing identification schemes that link the digital object to the source material. File naming is also an important consideration when transferring files via the Internet, where it may not be evident what computer platform was used when the files were originally created.įile names can be either descriptive or non-descriptive.
#Microsoft excel 2016 for mac formats time as decimal not time mac os x#
However, it is still possible to run into problems related to filename length.Īdopting good file naming conventions can help ensure that files will work with different operating systems and disk formats, such as Windows, Linux, Mac OS X and UNIX. These computers used the 8.3 filename which allowed eight characters to the left of a period with three characters to the right to tell the computer which application to use to display it. Most file systems today, and the operating systems that incorporate them, support much longer file names than the personal computers that ran Microsoft DOS and early versions of Windows. Cell phones, tape drives, networking equipment, televisions, and even digital cameras support file systems today.
#Microsoft excel 2016 for mac formats time as decimal not time windows#
While the vast majority of desktop computers still use Microsoft Windows or the Macintosh OS, there remain many other operating systems (and file systems ) that can interact with files at different points. The adoption of the UNICODE standard for character encoding and cross compatibility between operating systems has made problems opening a file received as an attachment to an email, downloaded from a web site, or accessed on a cloud storage platform extremely rare, but problems can still occur. Advances in computing have made moving files between different platforms much easier than just a few years ago.
