Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to enter telephone numbers in Excel sheet
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 |
#2
|
|||
|
|||
You need to format the cells as text to stop excel interpreting the data you
have entered as numbers. Nick "UMA" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
#5
|
|||
|
|||
If you had included spaces when you created them, you would
have no problem because they would be text. Since the lengths of phone numbers vary, I'm not sure how you got away with just digits and had leading zeros.. Excel is limited to 15 digits, if you exceed that your phone numbers are no good, and you would have to fix your input, or what might work is to change the extension of your input from .csv to .txt so that the Text Import Wizard comes up. Then indicate that the column is delimited, and later on that specific columns are text. Otherwise, if you can't do that... Try Formatting under Format, cells, custom as 000 000 000 0000 whatever it takes to format the digits so that you can retain leading zeros. For instance if you numbers looked like 91 33 22445566 you would format as 00 00 00000000 011 91 33 22445566 you would format as 000 00 00 00000000 Once you get them correct, I would consider using a macro to change them to text i.e. cell.value = "'" & cell.text --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "UMA" wrote in message ... 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 |
#6
|
|||
|
|||
Dear Mr.David McRitchie,
Thank you very much, your suggestion has helped me partly. I could retrieve few numbers except for those with zeros in the end. Like first 4 numbers are ok but after that all are zero's. i couldn't retrieve this but others were ok. Thank you once again. "David McRitchie" wrote: If you had included spaces when you created them, you would have no problem because they would be text. Since the lengths of phone numbers vary, I'm not sure how you got away with just digits and had leading zeros.. Excel is limited to 15 digits, if you exceed that your phone numbers are no good, and you would have to fix your input, or what might work is to change the extension of your input from .csv to .txt so that the Text Import Wizard comes up. Then indicate that the column is delimited, and later on that specific columns are text. Otherwise, if you can't do that... Try Formatting under Format, cells, custom as 000 000 000 0000 whatever it takes to format the digits so that you can retain leading zeros. For instance if you numbers looked like 91 33 22445566 you would format as 00 00 00000000 011 91 33 22445566 you would format as 000 00 00 00000000 Once you get them correct, I would consider using a macro to change them to text i.e. cell.value = "'" & cell.text --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "UMA" wrote in message ... 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 |
#7
|
|||
|
|||
Did you create a custom format to match the format of your phone numbers
ahead of time. Of course I think it will only work if all your phone numbers are the same length. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "UMA" wrote in message ... Dear Mr.David McRitchie, Thank you very much, your suggestion has helped me partly. I could retrieve few numbers except for those with zeros in the end. Like first 4 numbers are ok but after that all are zero's. i couldn't retrieve this but others were ok. Thank you once again. "David McRitchie" wrote: If you had included spaces when you created them, you would have no problem because they would be text. Since the lengths of phone numbers vary, I'm not sure how you got away with just digits and had leading zeros.. Excel is limited to 15 digits, if you exceed that your phone numbers are no good, and you would have to fix your input, or what might work is to change the extension of your input from .csv to .txt so that the Text Import Wizard comes up. Then indicate that the column is delimited, and later on that specific columns are text. Otherwise, if you can't do that... Try Formatting under Format, cells, custom as 000 000 000 0000 whatever it takes to format the digits so that you can retain leading zeros. For instance if you numbers looked like 91 33 22445566 you would format as 00 00 00000000 011 91 33 22445566 you would format as 000 00 00 00000000 Once you get them correct, I would consider using a macro to change them to text i.e. cell.value = "'" & cell.text --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "UMA" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to update functions in excel sheet? | Excel Worksheet Functions | |||
Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |