aproblem whit cpncatenate function

[EDN Admin]

<table border="0" cellpadding="0" cellspacing="0" dir="rtl" width="971" style="width:728pt; border-collapse:collapse
<colgroup><col width="971" style="width:728pt </colgroup>
<tbody>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" width="971" style="width:728pt; height:14.25pt
HEY,<span> </td>
</tr>
<tr height="19" style="height:14.25pt
</tr>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" style="height:14.25pt I HAVE EXCEL 2007, THE PROBLEM IS WHIT CONCATENATE FUNCTION.</td>
</tr>
<tr height="19" style="height:14.25pt
</tr>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" style="height:14.25pt WHEN IM DOING =CONCATENATE(999711100100,300,10196) I GETTING THE NUMBER<span> </td>
</tr>
<tr height="19" style="height:14.25pt
<td dir="ltr" height="19" style="height:14.25pt 99971110010030000000</td>
</tr>
<tr height="19" style="height:14.25pt
</tr>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" style="height:14.25pt so far so good, but when im doing on the number f2 and then f9 and enter (convert it to a number) ,im getting adifferent number (99971110010030000000).</td>
</tr>
<tr height="19" style="height:14.25pt
</tr>
<tr height="19" style="height:14.25pt
</tr>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" style="height:14.25pt i must convert it to anumber becaue i want to do on this number a vlookup function.</td>
</tr>
<tr height="19" style="height:14.25pt
</tr>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" style="height:14.25pt can you help me please?</td>
</tr>
<tr height="19" style="height:14.25pt
</tr>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" style="height:14.25pt thanks.</td>
</tr>
<tr height="19" style="height:14.25pt
<td align="left" dir="ltr" height="19" style="height:14.25pt efi</td>
</tr>
<tr height="19" style="height:14.25pt
</tr>
</tbody>
</table>

View the full article