Nov 12 2018 04:28 AM
In attached file, there is some number-look text in Arabic font . I couldn't convert them to number. non of these 4 ways helped me:
1- use Value function
2- use paste special
3- use error checking
4- use text to column
Please help me to convert these text to number.
Nov 12 2018 09:24 AM
Hi,
It looks like you copy that from Web. You have some extra symbol at the end of your arabic numbers. If you double click on the cell and remove it when works. Or use
=VALUE(LEFT(A1,LEN(A1)-1))
But not always - perhaps there are more not-numeric symbols. Please check attached, that could give you an idea.
Nov 13 2018 11:01 PM
Thank you very very much.
I copy them from html file. You are right, there was an extra character, a non breaking space (ctrl+shift+space). your solution was excellent.