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