Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



My first move in a fresh Excel workbook is Select All, Format Cells as Text.


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.




Consider applying for YC's Fall 2026 batch! Applications are open till July 27.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: