Changing cell types from "General" to "Text" before initial data input can prevent unintended reformatting issues. Some of these changes revert the cell back to its original value when changing the cell type to a literal 'text' value and some do not. These programs may automatically format any data entered into a cell, which can include removing leading zeros or reformatting date and time cells in some cases, this may alter the meaning of the data. Do not rely on special formatting that is available in spreadsheet programs, such as Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |