| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorry i put wrongly for padded leading 0
dear all
this is to pad with trailing 0 =IF(D2<14, D2&REPT("0",14-LEN(D2)),D2) why when i put in this way it doesn't seem to work? =IF(D2<14, REPT("0",14-LEN(D2)&D2),D2) thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sorry i put wrongly for padded leading 0
I suspect you IF condition is written improperly -- I think this is what you
want. =IF(LEN(D2)<14,REPT("0",14-LEN(D2))&D2,D2) -- Regards, Tom Ogilvy "tango" wrote in message om... dear all this is to pad with trailing 0 =IF(D2<14, D2&REPT("0",14-LEN(D2)),D2) why when i put in this way it doesn't seem to work? =IF(D2<14, REPT("0",14-LEN(D2)&D2),D2) thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas calculate the answer wrongly as 0 | Excel Worksheet Functions | |||
| Getting month padded zero | Excel Discussion (Misc queries) | |||
| wrongly added or subtracted decimals | Excel Discussion (Misc queries) | |||
| Time displaying wrongly | Excel Discussion (Misc queries) | |||
| padded leading 0 | Excel Programming | |||
Linear Mode
