MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Posted by Michelle on February 20, 2001 7:39 AM

It is because Excel sees it as a single number. If it is possible to enter spaces after the comma it will no longer read it as a number. Ex: 379, 771, 137, etc...

Posted by cpod on February 20, 2001 7:56 AM

You will have to change the number to text: