Help

[Soth]

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

 

[Gary''s Student]

Format the cells as follows:

Format > Cells... > Number > Number and use 0 decimal places

 

[Soth]

Gary - Thank you very much.

Format the cells as follows:

Format > Cells... > Number > Number and use 0 decimal places