formatting cells

[bikewider]

Hello All,

1st post. I'm sure this topic has been covered numerous times, so please re-direct me to the right location. I am NOT a super strong user in this area. I would like to setup a worksheet with cells that can only have the following:

alpha characters only in some cells.
Numeric characters in some cells .
Numeric characters with no decimal allowed.

etc,etc.

Thanks in advance

BW

[FDibbins]

Format your data entry areas using data/data validation, this should give you what you need

[bikewider]

Dear FDibbins,

Thank you very much. Extremely helpful.

BW

[bikewider]

one more example please. Could you detail how I would set up a cell to allow alpha characters only??

Regards,

BW

[jetted]

Hi would look in regular expression
If you're able to add "Microsoft VBScript Regular Expressions" as a reference to your project, you can use the following:

Please Login or Register  to view this content.

Regular expressions are very powerful. I'm not sure if this will run faster than your loop, but it's worth a shot. More info on RegExp can be found at http://msdn.microsoft.com/library/de...xpressions.asp