Disable typing certain character.

Microsoft Windows xp inside out, second...
January 22, 2010 at 01:45:10
Specs: Windows XP, pentium 4 3.00Ghz. 1gb ram
How to disable typing "$"(without quote) in col. E, F & G of sheet1?.

The columns is formated with currency format so that when a user input any number it will be preceded with $ but i want the cells rejects when user type in $ symbol manually.

See More: Disable typing certain character.

Report •

January 22, 2010 at 04:08:10

I don't think it makes any difference to the data in the cell whether the user types the $ sign or not when entering data in a cell formatted as currency.

Excel recognizes $ as a currency symbol and just stores the data.


Report •

January 25, 2010 at 02:12:57
Ok. how to restrict entering non-numeric in these columns but allow pre-formated currency symbol $?

Report •

January 25, 2010 at 04:47:01

Apply data validation to the cells:

In Excel 2003 (slightly different in Excel 2007), from the Menu - Data - Validation... Then in the dialog box select the Settings Tab, and in the Allow: drop-down select Decimal.
Enter two values in the Minimum and Maximum boxes.
Click OK

This will limit data entry to numbers in your range - if lowest value is zero it will stop negative numbers being entered and text (that isn't a number) cannot be entered.

In the Validation dialog, once you have entered Min and Max values you can create a custom alert warning in the Error Alert Tab - this shows if the entry fails the validation test.

You could also add a pop-up message that shows whenever the cell is selected - e.g. Enter dollar amount without the $ sign.


Report •

Related Solutions

January 25, 2010 at 18:45:19
Thanks Humar. Thats what i tried but i used whole number
instead of decimal.

Report •

Ask Question