| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add zeros to fill in and | Excel Worksheet Functions | |||
| add zeros to fill in and | Excel Worksheet Functions | |||
| add zeros to fill in and | Excel Worksheet Functions | |||
| How do I make a number have leading zeros to fill width of cell? | Excel Discussion (Misc queries) | |||
| fill or truncate to a certain number of characters in a cell | Excel Worksheet Functions | |||
Hybrid Mode
