how to enter telephone numbers in Excel sheet

You need to format the cells as text to stop excel interpreting the data you
have entered as numbers.

Nick

"UMA" <UMA@discussions.microsoft.com> wrote in message
news:A56EF150-2C63-4822-8019-EB38647F022E@microsoft.com...
> when i uploaded my Phone Book from my Mobile into Excel sheet i am unable
> to
> see the correct number but it appears like 1.79511E+15 and also when i
> remove
> the first few numbers like country code etc still the number appears to
> be
> wrong with so many zeros at the end (like last 4-5 numbers appear as "0")i
> am
> unable to get the correct number. Please help to retrive the correct
> numbers.
>
> Thanking You in Advance
>
>

Dear Nick,

Can i format the cell as text now to already saved excel sheet, where i have
saved my Phone Numbers.



"Nick" wrote:

> You need to format the cells as text to stop excel interpreting the data you
> have entered as numbers.
>
> Nick
>
> "UMA" <UMA@discussions.microsoft.com> wrote in message
> news:A56EF150-2C63-4822-8019-EB38647F022E@microsoft.com...
> > when i uploaded my Phone Book from my Mobile into Excel sheet i am unable
> > to
> > see the correct number but it appears like 1.79511E+15 and also when i
> > remove
> > the first few numbers like country code etc still the number appears to
> > be
> > wrong with so many zeros at the end (like last 4-5 numbers appear as "0")i
> > am
> > unable to get the correct number. Please help to retrive the correct
> > numbers.
> >
> > Thanking You in Advance
> >
> >
>
>
>

UMA

Won't do you any good to Format after the fact.

Format a column as Text then re-paste the numbers.


Gord Dibben Excel MVP

On Thu, 5 May 2005 09:11:02 -0700, UMA <UMA @discussions.microsoft.com> wrote:

>Dear Nick,
>
>Can i format the cell as text now to already saved excel sheet, where i have
>saved my Phone Numbers.
>
>
>
>"Nick" wrote:
>
>> You need to format the cells as text to stop excel interpreting the data you
>> have entered as numbers.
>>
>> Nick
>>
>> "UMA" <UMA@discussions.microsoft.com> wrote in message
>> news:A56EF150-2C63-4822-8019-EB38647F022E@microsoft.com...
>> > when i uploaded my Phone Book from my Mobile into Excel sheet i am unable
>> > to
>> > see the correct number but it appears like 1.79511E+15 and also when i
>> > remove
>> > the first few numbers like country code etc still the number appears to
>> > be
>> > wrong with so many zeros at the end (like last 4-5 numbers appear as "0")i
>> > am
>> > unable to get the correct number. Please help to retrive the correct
>> > numbers.
>> >
>> > Thanking You in Advance
>> >
>> >
>>
>>
>>