3 ms·

If you pre-format the cell as text, any value input will be stored in its entirety. For one offs, prepending any string with ' will force Excel to store as text

If you pre-format the cell as text, any value input will be stored in its entirety. For one offs, prepending any string with ' will force Excel to store as text. For date, it typically does not truncate seconds, so not sure what's happening there.

jmelloy 14y ago
If I were to pick one thing I wish Excel handled better out of the box, it was it's annoying habit of reformatting numbers pasted in.
vdm 14y ago
My first move in a fresh Excel workbook is Select All, Format Cells as Text.