Select the Value and Apply Custom Format 0
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Skanda
Sent: Friday, June 17, 2011 3:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pad zeros
Hi,
How to add zeros in front
It will increase length of value
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of nehal sejpal
Sent: Friday, June 17, 2011 9:07 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Pad zeros
Put '000745689002346789
On Fri, 17 Jun 2011
Hi Skanda,
Please use Below formula for our query.
=REPT(0,(9-LEN(B4)))B4
*Best Regards,*
*Venkat*
On Fri, Jun 17, 2011 at 3:46 AM, Skanda skanda.pokkun...@gmail.com wrote:
Hi,
How to add zeros in front of a value with varying lengths so that the
length of the column is 9?
for instance
instead of using below formula you can use.
this formula it will work in any cell and for any value.
*=REPT(0,LEN(B4)+(2)-LEN(B4))B4
*
On Fri, Jun 17, 2011 at 10:46 AM, Venkatesan c venkat1@gmail.comwrote:
Hi Skanda,
Please use Below formula for our query.
=REPT(0,(9-LEN(B4)))B4
Hi Skanda,
you can do one thing, first select the numbers and then go to
Format Format cells number tab custom 0
In case any query, please feel free to contact.
Thanks Regards,
Manish Singh Bankoti
On Fri, Jun 17, 2011 at 3:46 AM, Skanda skanda.pokkun...@gmail.com wrote:
Hi,
Put '000745689002346789
On Fri, 17 Jun 2011 08:08:15 +0530 wrote
Hi,� How to add zeros in front of a value with varying lengths so that the
length of the column is 9?for instance a column policy id has values with
varying lengths as follows:�
Policyid:�7456892346789��so i need to transform
add ' sign before the policy id '00078999...
check the attachment
On Fri, Jun 17, 2011 at 9:07 AM, nehal sejpal nehal_c...@rediffmail.comwrote:
Put '000745689002346789
On Fri, 17 Jun 2011 08:08:15 +0530 wrote
Hi,� How to add zeros in front of a value with varying lengths so that the
Hi Skanda,
Assuming the data provided by you is in Column A, use following formula:-
=REPT(0,9-LEN(A2))A2
Sample worksheet is attached herewith.
Let me know if this helps.
Best Regards,
DILIPandey
On 6/17/11, Skanda skanda.pokkun...@gmail.com wrote:
Hi,
How to add zeros in front of a