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.