number in cell is different to the way I want it , please help
Posted by locutus on February 20, 2001 5:36 AM
I have a cell which has this in it:
these are actually project numbers that have been entered. I am writing a program to extract these project numbers. Although the cell has the above in it when I look in the equals ( =) section at the top of the sheet the number is displayed as 3.79771137373653E+26 , when I link to access with this spreadsheet this is the value placed in my table and then I cant extract the project numbers from it. Do you know how I can make the number be the way I want in excel and its link to a table.
Cheers , Locutus