restricting use of certain characters

From: "Rob" <none>
Date: Tue, 6 Jun 2006 11:28:48 +0930

Hi,

I'd like to know how to restrict entry of certain characters (those that
windows won't allow when naming a file, particularly the / sign)

EG, the person may want to enter 07/77147 into a cell and I want either a
message to appear saying the / is invalid or, with an option for the / to be
automatically changed to a -.

Is this possible?

Rob

.

Follow-Ups:
- Re: restricting use of certain characters
  - From: Zygan

Prev by Date: Re: Create Macro to Copy Data from one spread*** to another
Next by Date: Unable to merge cells
Previous by thread: Re: excel 97 vs excel 2003
Next by thread: Re: restricting use of certain characters
Index(es):
- Date
- Thread