Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
Gary - Thank you very much.
"Gary''s Student" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|