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