whenever i add a phone numer in excel / csv the zerp disappear!!!! and some numbers become symbols! how do i stop this from happening ? thanks!
2006-11-14 03:52:22 · 11 answers · asked by YabbaJabba 3 in Computers & Internet ➔ Software
right click in the box and go to format cells then change to text
2006-11-14 03:55:37 · answer #1 · answered by scragette2000 5 · 0⤊ 0⤋
Change the format of the cell to text
Right click the cell - Format Cells - select Text.
2006-11-14 12:04:28 · answer #2 · answered by Siu02rk 3 · 0⤊ 0⤋
If you want to keep leading zeros, you need to change the format to TEXT. However, if you save it as a CSV file and reopen it, you will lose the leading zeros again. If you really want to see the actual values in a CSV file, open it in Notepad.
2006-11-14 12:04:22 · answer #3 · answered by gandalf 4 · 0⤊ 0⤋
Instead of Text, format your cell as a phone number; it's available under Special.
2006-11-14 18:36:53 · answer #4 · answered by O Caçador 6 · 0⤊ 0⤋
Change the format of the cells to text
2006-11-14 11:57:15 · answer #5 · answered by Sir Sidney Snot 6 · 0⤊ 0⤋
Select the column (click on the letter above the header), then click Format, Cells, choose Text.
2006-11-14 12:04:06 · answer #6 · answered by TheHumbleOne 7 · 0⤊ 0⤋
A quick fix is to format the cell as something other than number. (Hold CTRL and press 1, change format to text for example and press OK.)
2006-11-14 12:02:56 · answer #7 · answered by Anonymous · 0⤊ 0⤋
Format the cell as text as for the symbols like ### widen the cell.
2006-11-14 12:02:27 · answer #8 · answered by Crazy Diamond 6 · 0⤊ 0⤋
Put an apostrophe ' in front to the telephone number. This tells Excel to put it in just as typed
2006-11-14 11:58:51 · answer #9 · answered by SteveT 7 · 0⤊ 0⤋
When you use ' anything stays exactly as you key it after that.
For example: '0057876 will be 0057876
If you don't use the ' it drops the leading zeros.
Hope this it the answer you were looking for...
2006-11-14 11:57:43 · answer #10 · answered by Milkaholic 6 · 1⤊ 0⤋