Want to combine celll values

custom format the cents cells as 00

Is that what you mean?

regards

Dav

Originally Posted by Dav

custom format the cents cells as 00

Is that what you mean?

regards

Dav

Have you opened the attached doc? if i format that cents column as 00 it will be wrong. right? coz if i have written 50 cents it will become 50.00!!!!!! dats not good. this is the way i want, for 1 cents = 01, 2cents = 02, 0 cents = 00, 50 cents = 50 .like that. got it?

Originally Posted by Dav

custom format the cents cells as 00

Is that what you mean?

regards

Dav

Hi buddy u r correct. it worked. these days my mind is in "zero" so i cannot use it to THINK about anything. hehehe. i am tired. thannks once again.

And thanks for the Administrator for moving this thread to the where it belongs to. thank you