MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using numbers only


Posted by J Tompson on August 15, 2001 7:24 AM

Hi,

I would like to make sure that the users of my spreadsheet use numbner only for two ranges on the sheet. I've named the range but the code i'm using to ensure that nunmbes only are used doesn't work very well ie. it causes excel to crash.

Can anybody give me any idea how to over come this? I want numbers but no text.

Cheers in advance.

John


Posted by Mark W. on August 15, 2001 8:00 AM

Use data validation (see the Data | Validation...
menu command) with a Custom validation critera
using the formula, =ISNUMBER(ref), where "ref"
is a cell reference to the cell you wish to
regulate data entry.