Not allowing Alpha Characters in a Numeric Formatted Column

C

CaptainBly

I have a spreadsheet that we provide to vendors where they have to fill
in their product data and send it back to us where we import this data
into the products database.

I have the spreadsheet set up the way I want it and have drop down
boxes where applicable for data validation.

I have several fields that i only want #'s. Sometimes integers,
sometimes there may be a decimal. I set the formats accordingly.

HOwever, you can still type the letter A or B or C etc... in there. I
only want them to be able to type in #'s.

In access I can use a mask. Is there anything similar in Excel that
will force this issue?

Thanks in advance for any suggestions.
 
A

Alan

If you use validation and select 'Decimal', minimum value 0.001, maximum
20,000 or whatever, only numbers can be entered,
Regards,
Alan.
 
S

SteveG

You can use data validation for those cells to restrict the user fro
putting in alpha characters.

Data>Validation

Allow>Decimal

Set your minimum at something much lower than you will ever see an
your maximum higher. I tested with .0000000001 and 2,000,000. Thi
will limit users to numbers (whole or decimal) from your MIN up to you
MAX. No Alpha characters will be accepted.

Does that help?

Stev
 
C

CaptainBly

That should do it. I did data validation to create my lists. Didn't
think of it for this.

Thanks.
 
C

CaptainBly

That should do it. I did data validation to create my lists. Didn't
think of it for this.

Thanks.
 
Top