In the old versons of excell I was able to format a number such as a cell number to start with 0 and then break the number down to have a space after the third and sixth digit via the custom text field in format number using 0## ### ####. Simelarly I could achieve the same effect with text(A1,"0## ### ####"). Now the result is "0 ### ### ###. I cant get rid of the space after the zero and make the number look like a cell number anymore. Any solution?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Converting a number to text in the format "0## ### ####
- Thread starter Alex11
- Start date
Similar threads
- Solved
- Question
