Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello. Please help me if possible.
I need a function that will take a value that may be 1 to 3 digits in length and 0 to 2 decimal places and pad it to always have three digits and two decimals. For example: 1 would be converted to 001.00 14 would be converted to 014.00 15.3 would be converted to 015.30 145 would be converted to 145.00 197.21 would remain 197.21 The variable(s) can be strings if needed, I can work with any VBA compatible datatype. Your example code to do this would be most appreciated. Thanks in advance for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell padding | Excel Discussion (Misc queries) | |||
How to Change the Cell Padding | Excel Discussion (Misc queries) | |||
Padding and Concatenate | Excel Discussion (Misc queries) | |||
Padding with leading zeros | Excel Discussion (Misc queries) | |||
padding ? | Excel Discussion (Misc queries) |