E
Eddy Stan
Hi all,
original text in cell c4:
Out of total dues of Rs.855.8k bills for INR 651.2k were rebilled and
resubmitted for payment and the balance of Rs 204,600 are under process.
required text in cell d4:
Out of total dues of INR 855.8k (SGD 25,365) bills for INR 651.2k (SGD
19,308) were rebilled and resubmitted for payment and the balance of INR
204.6k (SGD 6,066) are under process.
that is, multiply by 1000 and divide by 33.7272 (value at d1 cell), there
could be more numbers in the same cell. Except numbers all the other text
should be same in d4. Third numbe is very typical, pl note.
the number will be prefix with "Rs.","INR","Rs ", suffix will be "k" or no "k"
these type of changing to be done for some 200 to 300 rows, all the time.
Can any one help me.
original text in cell c4:
Out of total dues of Rs.855.8k bills for INR 651.2k were rebilled and
resubmitted for payment and the balance of Rs 204,600 are under process.
required text in cell d4:
Out of total dues of INR 855.8k (SGD 25,365) bills for INR 651.2k (SGD
19,308) were rebilled and resubmitted for payment and the balance of INR
204.6k (SGD 6,066) are under process.
that is, multiply by 1000 and divide by 33.7272 (value at d1 cell), there
could be more numbers in the same cell. Except numbers all the other text
should be same in d4. Third numbe is very typical, pl note.
the number will be prefix with "Rs.","INR","Rs ", suffix will be "k" or no "k"
these type of changing to be done for some 200 to 300 rows, all the time.
Can any one help me.