zennon
03-14-2007, 08:38 AM
Need help on something that I have never seen done automatically before. I need to populate cells with numeric data from another sheet (This I can do), what I need help with is:
Cell value will be a currency amount e.g. 241.65 I need to make this field a certain length by adding zeros to the amount to make the length 15 characters long with a minus sign at the end for the 15th character. e.g. 00000000241.65-
The thing I need to find out is that all values can be diferent lengths e.g. 1254.25, 10245.85. I need to run a check to see the length and add the appropriate number of zeros to make the 15 characters.
I need to do this with other cells but these will be alpha characters.
HELP!!!!:help
Cell value will be a currency amount e.g. 241.65 I need to make this field a certain length by adding zeros to the amount to make the length 15 characters long with a minus sign at the end for the 15th character. e.g. 00000000241.65-
The thing I need to find out is that all values can be diferent lengths e.g. 1254.25, 10245.85. I need to run a check to see the length and add the appropriate number of zeros to make the 15 characters.
I need to do this with other cells but these will be alpha characters.
HELP!!!!:help