Formatting long decimal numbers as TEXT cell, not refreshing?

[Al Franz]

I have some long numbers in an Excel cell such as 0.100300015999999. Since
these are part numbers I do not want to specifiy the formatting with a
certain number digits past the decimal. In the cells they currently only
display 9 digits past the decimal (i.e. 0.100300015) even though the full
number is contained in the cell as displayed in the formula bar. I reformat
them as a TEXT cell and it does not change. I can click on the number in the
formula bar (i.e. where it is displayed in the excel space below the ribbon
bar) and the specific cell will then properly change and display the whole
number. But I can not individually go through this for the entire
spreadsheet. How can this be refreshed after re-formatting the entire
column as TEXT ?

 

[ShaneDevenshire]

Hi,

we don't know the layout of your data but suppose these numbers are in the
range B2:B1000 then in an empty column, say column C, in C2 enter
=LEFT(B2,20)
Copy this down to C1000.
Select C2:C1000 and choose Copy, then Edit, Paste Special, Values.
Remove the original number and use these.


If this helps, please click the Yes button.

 

[muddan madhu]

select the cells | go to format | cells | number tab | category :
number | decimal places (select as much you want) | ok