Prev: undo concatenated cells
Next: i downloaded a plug in and it does not show up in the ribbon
From: Matt on 24 Feb 2010 22:13
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
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: undo concatenated cells
Next: i downloaded a plug in and it does not show up in the ribbon