Fill a 15 Characters Data with Zeros
 

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.

Fill a 15 Characters Data with Zeros
 

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

Fill a 15 Characters Data with Zeros
 

this may work for you

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

--


Gary Keramidas
Excel 2003


"ileanardz" wrote in message
...
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.

Fill a 15 Characters Data with Zeros
 

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 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 -

Fill a 15 Characters Data with Zeros
 

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 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.

Fill a 15 Characters Data with Zeros
 

A variation to Dave's formula:

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

This analyzes the length of the value in cell A1 and adds the appropriate
number of zeros to get to a total length of 15. This allows any number of
decimal places.

"Dave Peterson" 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
.