Hello,
I need to get this number '765102700063500 into this format 76510-27-000-635-00
Can someone please help?
Thanks!
Hello,
I need to get this number '765102700063500 into this format 76510-27-000-635-00
Can someone please help?
Thanks!
Custom number format...
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
One way:
=TEXT(A2,"00000-00-000-000-00")
CK76's is better. Go with it...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you Glenn. I like your formula better since i have a lot of numbers that i would have to convert to this format.
Thank you CK76 .
You are welcome. You know that you can copy paste custom number formats right?
The main reason for using CK76's is that it remains a number, whereas my formula produces text that looks like a number.
Thanks CK76 I am not familiar with it. I have a list of numbers that i need to convert to the format that i had mentioned earlier. How would you do that?
Thanks, I was able to use the formula and pull it down the list and it converted all the numbers into the desired format.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks