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

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.