If you have copied numbers from PDF / HTML format to Excel and Numbers have converted to text format, and is not being fixed by changing format, you may try following:
If you copy data from a website, it might include hidden characters, such a non-breaking space. In Excel, this is character 160, and it is not fixed by some of the number cleanup techniques. You can search for that character, and replace it.
1. Select the cells that contain the numbers to be fixed
2. On the Ribbon's Home tab, click Find & Replace (at the far right)
3. Click Replace
4. For Find what, press the Alt key, and on the number keypad, press 0160 (nothing will appear in the box)
5. For Replace with, leave the box empty
6. Click Replace All
7. Click OK to confirm the replacement, then close the Find and Replace window .
If you copy data from a website, it might include hidden characters, such a non-breaking space. In Excel, this is character 160, and it is not fixed by some of the number cleanup techniques. You can search for that character, and replace it.
1. Select the cells that contain the numbers to be fixed
2. On the Ribbon's Home tab, click Find & Replace (at the far right)
3. Click Replace
4. For Find what, press the Alt key, and on the number keypad, press 0160 (nothing will appear in the box)
5. For Replace with, leave the box empty
6. Click Replace All
7. Click OK to confirm the replacement, then close the Find and Replace window .
No comments:
Post a Comment