Format the cells as follows:

Format Cells... Number Number and use 0 decimal places
--
Gary''s Student - gsnu200838


"Soth" wrote:


Hello

I'd like to see these below number 2.21211E+16 into full number as
22121073440011900 and in doing so I have to had the apostrophe infront. I
have to do this with thousands of items. Is there a better way to achieve
this?

Thanks,
Soth

2.21211E+16
2.21211E+16
2.21211E+16
2.21211E+16