I wrote a script that creates an HTML table like this for a coworker:
<table>
<tr>
<td>06/21/2014</td>
<td>AAA</td>
</tr>
<tr>
<td>06/22/2014</td>
<td>BBB</td>
</tr>
<tr>
<td>06/23/2014</td>
<td>CCC</td>
</tr>
</table>
When she pastes it into Excel, she either gets this:
|6/21/2014|AAA|
|6/22/2014|BBB|
|6/23/2014|CCC|
Where the date strings have had the preceding 0 removed, this breaks a find/replace we're trying to do on dates. Or, if she tries to paste special -> text on her windows PC she gets this:
|06/21/2014|AAA |
|06/22/2014|BBB |
|06/23/2014|CCC |
If I paste special on a mac, it works fine. Is there a way to:
- turn off default auto date formatting for all new files? OR
- make the paste special text stop adding trailing spaces?