Thank you all.it works like a charm!!
On Fri, Jun 17, 2011 at 7:28 AM, Rakesh Joshi wrote:
> 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 wrote:
>
>>
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 wrote:
> Hi Skanda,
>
> Please use Below formula for our query.
> =REPT(0,(9-LEN(B4)))&B4
>
> *Best Regards,*
>
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 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
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
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 i
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 wrote:
> Hi,
> How to add zeros in front of a value with varying lengths s
add ' sign before the policy id '00078999...
check the attachment
On Fri, Jun 17, 2011 at 9:07 AM, nehal sejpal wrote:
>
> 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
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
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 wrote:
> Hi,
> How to add zeros in
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:
745689
2346789
so i need to transform the above policyid to:
000745689
002346789
--
10 matches
Mail list logo