General Help

[ehlfb]

I used to send our staff bank transfer sheet to the bank with the following format:

Name; Bank A/C; Amount
XXXXX; 1-32-6666-130; 4540.500


Now the bank has asked for the following format

Name; Bank A/C; Amount
Bank A/C: has to be (12) digits 0001-32-6666-13 which means I have to add 00, 000 or 0000 (depend on the account number) at the left.
Amount: has to be (8) digits with no decimls (04540500) if less than (8) I have to add Zeros at the left.

I would appreciate it if anyone can help me in this.

 

[CWatts]

This can be done pretty easily. As an example here's the amount shown as 00000.000 number format, and then removing the decimal:

=SUBSTITUTE(TEXT(J14,"00000.000"),".","")

You can mess around with that, or if you can post more detail about your worksheet we can help you with more specific formulas.

 

[ehlfb]

Dear CWatts,

It works, appreciate your help. Thank you.