number in cell is different to the way I want it , please help
Posted by locutus on February 20, 2001 5:36 AM
Hi
I have a cell which has this in it:
379,771,137,373,653,000,000,000,000
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:
=TEXT(cellref,"#,###")
