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

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

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

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