hi all ,
can some body can help me on this,
a1 contains = r12
b1 i want it as = 000r12
is there any way to do this.
does this formula work for you (in cell B1):
="000"&A1
Hi
..Where will you use the 000r12 result??
Because a simple way to do this, is to use a helper column.
A1=r12 >> C1(helper & hide column)>>(Texr Format)>>000. Then in B1=C1&A1
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
sorry i di not give the clear information in a coloumn their are diffrent varities
like
a1: r12
a2 :123h
a3:125a
but all i want in 6 digits
how about
=IF(LEN(A1)>5,A1,REPT("0",6-LEN(A1))&A1)
..Then try this:
=IF(LEN(A2)=3;"000"&A2;IF(LEN(A2)=4;"00"&A2;IF(LEN(A2)=2;"0000"&A2;IF(LEN(A2)=5;"0"&A2;""))))
Is it ok for you?
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
hi all ,
thank you so much
i have found a simple way, it might be useful to you also some times
=RIGHT("000000"&a1,6)
neat!
Do you ever have values with more than 6 characters - if so, how do you want them treated? Your formula will give the right six characters, mine would give the whole of A1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks