How can I add a percentage sign to a cell with data validation

[Guest]

I need to limit the data that can be entered into a cell to numbers.
However, I need to add a percentage sign to the entry after the whole number.
Any suggestions on how this can be done?

 

[Dave R.]

Format the cell(s) as percentage. Then entering whole number 9 will result
in 9%.

 

[Guest]

I tried this already and the combination of formatting a cell as a percentage
while limiting the entries to numbers through the use a data validation
doesn't work. You can enter the number but as soon as you press enter and
the percentage sign appears the pop up box indicates that the entry is not
valid. Can you think of any way to get around this? Thanks.

 

[CLR]

Right-click on the cell, FormatCells > NumberTab > Custom > in the Type:
window enter 0"%"

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

That worked great. Thank you very much for the help.

Glen