Prev: undo concatenated cells
Next: i downloaded a plug in and it does not show up in the ribbon
From: ileanardz on 24 Feb 2010 21:09
I am getting nuts with this....

I have an amount in A1: 108.203

And I need to fill A2 that must be 15 characters with the value of A1
and the remain characters before the first number (1) must be fill
with Zeros.

E.I.:
The result must be:
A2= 00000000108.203

Is there a way to do it?
Thanks in advance for your help.
From: Dave Peterson on 24 Feb 2010 21:21
Maybe...
=text(a1,rept("0",11)&".000")

Is the number of decimal places always 3?



ileanardz wrote:
>
> I am getting nuts with this....
>
> I have an amount in A1: 108.203
>
> And I need to fill A2 that must be 15 characters with the value of A1
> and the remain characters before the first number (1) must be fill
> with Zeros.
>
> E.I.:
> The result must be:
> A2= 00000000108.203
>
> Is there a way to do it?
> Thanks in advance for your help.

--

Dave Peterson
From: Gary Keramidas on 24 Feb 2010 21:26
this may work for you

=REPT("0",15-LEN(A1))&A1

--


Gary Keramidas
Excel 2003


"ileanardz" <ileanardz(a)gmail.com> wrote in message
news:ef6aebef-c336-4a72-867c-68fa45fc5db0(a)e19g2000prn.googlegroups.com...
>I am getting nuts with this....
>
> I have an amount in A1: 108.203
>
> And I need to fill A2 that must be 15 characters with the value of A1
> and the remain characters before the first number (1) must be fill
> with Zeros.
>
> E.I.:
> The result must be:
> A2= 00000000108.203
>
> Is there a way to do it?
> Thanks in advance for your help.

From: ileanardz on 24 Feb 2010 21:48
Yes, it is part of the "must" even A1 could be .01
A2 must display .010

Thanks your help


On Feb 24, 8:21 pm, Dave Peterson <peter...(a)verizonXSPAM.net> wrote:
> Maybe...
> =text(a1,rept("0",11)&".000")
>
> Is the number of decimal places always 3?
>
>
>
>
>
> ileanardz wrote:
>
> > I am getting nuts with this....
>
> > I have an amount in A1: 108.203
>
> > And I need to fill A2 that must be 15 characters with the value of A1
> > and the remain characters before the first number (1) must be fill
> > with Zeros.
>
> > E.I.:
> > The result must be:
> > A2= 00000000108.203
>
> > Is there a way to do it?
> > Thanks in advance for your help.
>
> --
>
> Dave Peterson- Hide quoted text -
>
> - Show quoted text -

From: ileanardz on 24 Feb 2010 21:58
Thank you very much!!!!!
This really help me =)

This was the best for the .000
;)

=text(a1,rept("0",11)&".000")

Kind regards!!

On Feb 24, 8:09 pm, ileanardz <ileana...(a)gmail.com> wrote:
> I am getting nuts with this....
>
> I have an amount in A1: 108.203
>
> And I need to fill A2 that must be 15 characters with the value of A1
> and the remain characters before the first number (1) must be fill
> with Zeros.
>
> E.I.:
> The result must be:
> A2= 00000000108.203
>
> Is there a way to do it?
> Thanks in advance for your help.

 |  Next  |  Last
Pages: 1 2
Prev: undo concatenated cells
Next: i downloaded a plug in and it does not show up in the ribbon