LinkBack URL
About LinkBacks
I'd like to format a numer for example 12345678 - in the following way: 12.34.56.78. How can I do that?
Thanks in advance,
Marcelo Rychter
I'd like to format a numer for example 12345678 - in the following way: 12.34.56.78. How can I do that?
Thanks in advance,
Marcelo Rychter
I dont think you can do that using the cell format, for the simple fact that it wouldnt be a number anymore, it would be text.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
You can do it with a formula. Try:This will only work if your numbers are consistently 8 digits.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks