D
dyt
Has anyone seen this kind of misbehavior?
1. Create a table in HTML like:
<table><tr>
<td align="right" nowrap>214,074 </td>
<td align="right" nowrap>55,859 </td>
<td align="right" nowrap>26.09 </td>
<td align="right" nowrap>267,102 </td>
<td align="right" nowrap>71,365 </td>
<td align="right" nowrap>26.72 </td>
</tr></table>
(this is actually created by a very silly application
we bought)
2. Display it in your favorite browser
3. Copy it into an Excel spreadsheet
4. try to trim() or value() any of the values to get a
number. Doesn't work! What works is '=value(a1,len(a1)-
1)
!!!!
1. Create a table in HTML like:
<table><tr>
<td align="right" nowrap>214,074 </td>
<td align="right" nowrap>55,859 </td>
<td align="right" nowrap>26.09 </td>
<td align="right" nowrap>267,102 </td>
<td align="right" nowrap>71,365 </td>
<td align="right" nowrap>26.72 </td>
</tr></table>
(this is actually created by a very silly application
we bought)
2. Display it in your favorite browser
3. Copy it into an Excel spreadsheet
4. try to trim() or value() any of the values to get a
number. Doesn't work! What works is '=value(a1,len(a1)-
1)
!!!!