18 digit format

[Mark Devoto]

I am using Excel 2003 and want to show a sql report with cells containing 18 numerical digits but they appear like this <TABLE style="WIDTH: 65pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=87 border=0 x:str><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 65pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=87 height=17 x:num="3.5000166107743411E+17">3.50002E+17</TD></TR></TBODY></TABLE> If i format the cell as text it does not change.
Is there a way of formatting a work book and pasting the sql data in to it which will show the true 18 digits?

 

[grizz]

format your cell as text and put an apostrophe at the start of your numbers
This will tell excel to treat the data as text, apostrophe doesn't display