LOTUS 123 97 EDITION

[keppy]

1. I have a number which is aligned across two cells and centred
2. I also have the repeat of the above

3. I WISH TO HAVE A FORMULAE WHICH uses the result of 1 and 2 above which is also aligned across two cells .

4 The result in 3 above shows error but works ok if i remove the alignment

SO how do i allign across two cells for numbers and formulae

THANKS
Ken

 

[diogenes10]

The following makes some assumptions - basically that you cannot align numbers across more than 1 column so you must really be dealing with text.

Col A contains a number formatted as text centered across A and B

Col C contains a number formatted as text centered across C and D

E and F are formatted to center across the two columns.
E contains a formula @STRING(@VALUE(A1)+@VALUE(C1),2)

(My version is a little later, hopefully 97 will have those @ functions. )

Hope this is helpful.