View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dkellison dkellison is offline
external usenet poster
 
Posts: 2
Default alpha field getting turned into an exponential number

I have written an application that retrieves information and places it into
an Excel spreadsheet. I am having trouble with my Part Number field. For
example, the part number value is supposed to be 3067E17. But, that part
number is displayed as 3.07E+20 in the spreadsheet. Is there anything that I
can add to my application that would get the part number to display properly?
I have tried using NumberFormat = "@", but that did not help.