Not really unless they use text where you could look for the text strings,
otherwise it is just numbers with different formats (displays), there is a
function called cell("format") but that would not be very stable
--
Regards,
Peo Sjoblom
"martinco" wrote in message
...
Hi,
I would like to write a formula which allows the user to put in the
control
data as either a % or £ sterling. For example:
Rent £100 in year 1.
For year 2 they either know the % increase or have a fixed figure, IE
£200.
Is there a formula which would identify whether they have entered a % or £
figure?
Thanks
Ian
|