how do i increase the number of digits displayed
 

I am a person dealing with large numericals with digits more than 20 in
number(for eg. visa no:s and phone card no:s)..when I type in a no: such as
12345678912345678912 and enter the no: it is displayed as 1.23457E-27 how do
i enter such large no:s and have them displayed as such i.e without the
aforementioned formatting

Excel goes to 15 max so format as text or 'at the start of the number

--
Don Guillett
SalesAid Software

"ameen" wrote in message
...
I am a person dealing with large numericals with digits more than 20 in
number(for eg. visa no:s and phone card no:s)..when I type in a no: such
as
12345678912345678912 and enter the no: it is displayed as 1.23457E-27 how
do
i enter such large no:s and have them displayed as such i.e without the
aforementioned formatting

thanks a lot for the reply pal .. in fact thanx a million...

"Don Guillett" wrote:

Excel goes to 15 max so format as text or 'at the start of the number

--
Don Guillett
SalesAid Software

"ameen" wrote in message
...
I am a person dealing with large numericals with digits more than 20 in
number(for eg. visa no:s and phone card no:s)..when I type in a no: such
as
12345678912345678912 and enter the no: it is displayed as 1.23457E-27 how
do
i enter such large no:s and have them displayed as such i.e without the
aforementioned formatting

send the million

--
Don Guillett
SalesAid Software

"amn" wrote in message
...
thanks a lot for the reply pal .. in fact thanx a million...

"Don Guillett" wrote:

Excel goes to 15 max so format as text or 'at the start of the number

--
Don Guillett
SalesAid Software

"ameen" wrote in message
...
I am a person dealing with large numericals with digits more than 20
in
number(for eg. visa no:s and phone card no:s)..when I type in a no:
such
as
12345678912345678912 and enter the no: it is displayed as 1.23457E-27
how
do
i enter such large no:s and have them displayed as such i.e without
the
aforementioned formatting