LinkBack URL
About LinkBacks
Dear All
I have enter the number 6901019206088, how can I format a cell that displays the number in the format 690101 9206 088
Please could you help?
Warm Reagrds
Peter
Dear All
I have enter the number 6901019206088, how can I format a cell that displays the number in the format 690101 9206 088
Please could you help?
Warm Reagrds
Peter
Select the cell then press control+1 you will get a window format cell-> then go to custom-> You will see an option Type -> paste ###### #### ### this at the same place and then ok.
Hope it will help you
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thanks Ankur, this is the result I get however 6 901 019 206 088 even though I have entered ###### #### ###. It always defaults back to the # ### ### ### ### format.
Am I doing something stupid?
Peter
Maybe with a TEXT function
Assuming numeric values in A1
Formula:
Please Login or Register to view this content.
v A B 1 6901019206088 690101 9206 088
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for the suggestion Al, however I want to type the number directly into cell A1 and get the format as displayed in B1. Is that all possible?
Peter
Formatting also worked for me: ###### #### ### with Custom, so it should work for you too.
Edit: This format will work with 13 digit numbers only.
Last edited by AlKey; 07-15-2016 at 08:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks