Conditional format
 

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

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