Hi
I’m trying to export a table into HTML by generating html by hand (ie., using a formula such as "<tr><td>"&A1&"</td><td>"
…).
I have several columns that represent date/time. When I use the above formula, these get converted internally to their numeric representation, so I get
<tr><td>0.53125</td><td>0.5834</td></tr>
instead of
<tr><td>10:30 am</td><td>11:30 am</td></tr>
Is there some way to avoid this?
Also, the html export function generates too much of junk html code that is impossible to get rid of…
Thanks for any help
sb