| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
alpha field getting turned into an exponential number
Have you tried using the NumberFormat = "@" BEFORE you actually put the
text into the cell? If not, give it a shot. -JK dkellison wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
alpha field getting turned into an exponential number
I just tried using the NumberFormat = "@" before loading any data into the
cell and I still encounter the same problem. Thanks for the repsonse. dkellison "JK" wrote: Have you tried using the NumberFormat = "@" BEFORE you actually put the text into the cell? If not, give it a shot. -JK dkellison wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
alpha field getting turned into an exponential number
This works for me:
ActiveCell.NumberFormat = "@" ActiveCell.Value = "3067E17" Or, irrespective of the formatting: ActiveCell.Value = "'3067E17" NickHK "dkellison" wrote in message ... I just tried using the NumberFormat = "@" before loading any data into the cell and I still encounter the same problem. Thanks for the repsonse. dkellison "JK" wrote: Have you tried using the NumberFormat = "@" BEFORE you actually put the text into the cell? If not, give it a shot. -JK dkellison wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pvt Table Turned Values After Insert Calculated Field | Excel Discussion (Misc queries) | |||
| Looking for alpha characters in a field | Excel Worksheet Functions | |||
| Split Alpha Field | Excel Worksheet Functions | |||
| exponential into text or number | Excel Discussion (Misc queries) | |||
| Merge an alpha field and a numeric field | Excel Discussion (Misc queries) | |||
Linear Mode
