Hi
How do I have a formula that will automatically change 78 and 078 to 0078? I want everything in the four-digit format. It is ok if it is not a recognizable number.
thanks
LL
Hi
How do I have a formula that will automatically change 78 and 078 to 0078? I want everything in the four-digit format. It is ok if it is not a recognizable number.
thanks
LL
Please try this if it works.
Select the required cells & Navigate to
Ctrl + 1 > Number > Category > Custom > Type > Now enter 0000. (Four zeros)
Last edited by ramananhrm; 10-17-2013 at 06:11 AM.
Please click 'Add reputation', if my answer helped you.
hi LL. if you really want it to be 4 digits to be used on other formulas, use this formula:
=TEXT(A1,"0000")
the solution by ramananhrm is a visual effect for presentation. depends on what you require
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks