Conditional format
Try a custom format of
[<.5]0%;General
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Bee" wrote in message
...
Hi, how do I display a cell as follows:
If it's <50, show it as a %
If it's 50 show it as a decimal
It needs formating in the actual cell that the manager would enter a
figure
into.
Thanks
|