Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
sardonicbryan
on Feb 14, 2013
|
parent
|
context
|
favorite
| on:
Sorry, Geeks, Microsoft Excel is Everywhere
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.
vdm
on Feb 15, 2013
|
next
[–]
My first move in a fresh Excel workbook is Select All, Format Cells as Text.
jmelloy
on Feb 15, 2013
|
prev
[–]
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.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
For date, it typically does not truncate seconds, so not sure what's happening there.