Format Numbers
Hi!
I would like to know how can I format a number with more than 20 caracters to display it on cell. When I paste the value it shows like "8.955050340000140000000000000000E+19" Does someone know how to do it? -- Filipe |
Format Numbers
Hi,
Maximum digits is 15 so to display a larger number Put a ' in front of the number. Mike "Filipe" wrote: Hi! I would like to know how can I format a number with more than 20 caracters to display it on cell. When I paste the value it shows like "8.955050340000140000000000000000E+19" Does someone know how to do it? -- Filipe |
Format Numbers
Hi Filipe
Either pre-format the cell as Text or use a single quote in front of the number when entering '12345678901234567890 -- Regards Roger Govier "Filipe" wrote in message ... Hi! I would like to know how can I format a number with more than 20 caracters to display it on cell. When I paste the value it shows like "8.955050340000140000000000000000E+19" Does someone know how to do it? -- Filipe |
Format Numbers
I don't understand the question. The same as any other cell with a number,
you can format it as General, or as Number (with a defined number of decimal places), or as Scientific, or as a Percentage, or as Currency, or as ... What formatting are you trying to achieve, and what problem are you having when you do so? -- David Biddulph "Filipe" wrote in message ... Hi! I would like to know how can I format a number with more than 20 caracters to display it on cell. When I paste the value it shows like "8.955050340000140000000000000000E+19" Does someone know how to do it? -- Filipe |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com