Help with MI

[Korimint]

Hello,

I have this number:

<TABLE style="WIDTH: 141pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=188><COLGROUP><COL style="WIDTH: 141pt; mso-width-source: userset; mso-width-alt: 6875" width=188><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; WIDTH: 141pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: white 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl63 height=20 width=188>;60501100000002977693=2501</TD></TR></TBODY></TABLE>

I want it to be this number

6050110000002977693

I am using this formula to get the number:

=MID(Table1[[#This Row],[SPECID]],2,19)

which works, but when I add +0 to turn it back into a number this is what I get:

6050110000002900000

What am I doing wrong?

I am useing excel 2007, windows 7

Thanks for the help!

 

[MrKowz]

Excel only has a precision to 15 places on numbers.

http://www.cpearson.com/Excel/rounding.htm