Display percentage mark, don't x100

[clintonmadden]

Hi, I was wondering if anyone could help me..

I have a chart in which I want the user to enter a number, and if they forget to put in a percentage mark, to display one without the result being x100 if there's data in the cell.

Any help would be appreciated,

Clinton

 

[chergh]

Set up some data validation on the cell to allow decimal and require the value to be less than 1. Entering either "0.5" or "50%" will both work then but "50" won't.