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

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?

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



"Glen" wrote in message
...
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?

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.

"Glen" wrote:

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?

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

Vaya con Dios,
Chuck, CABGx3



"Glen" wrote in message
...
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?

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

Glen

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"Glen" wrote in message
...
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?