hello,
how can i pad a cell with zeroes? for example, i have records that must have a length of 10 characters, so if the number is 500.00, the left side must be padded with 5 zeros. is it possible to automate this for all the records (even if they have varying numbers?)
i would also like to do the same as above, but with the padding being spaces instead of zeros.
i am still not certain how to incorporate vbscript with excel...
how can i pad a cell with zeroes? for example, i have records that must have a length of 10 characters, so if the number is 500.00, the left side must be padded with 5 zeros. is it possible to automate this for all the records (even if they have varying numbers?)
i would also like to do the same as above, but with the padding being spaces instead of zeros.
i am still not certain how to incorporate vbscript with excel...