Excel datatype restrictions

Question

0.00/5 (No votes)

See more:

I need to put restrictions on excel columns for datatypes. If I format cell and choose the datatype as numeric, it still allows me to enter text. Please suggest some solution.

Posted 20-Dec-10 18:53pm

nattynids

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Slacker007 · Accepted Answer · 2010-12-20T21:42:00

Solution 1

I did a simple search in Google and the first hit is this: See here[^]

For future reference, you could have done this yourself. ;)

Posted 20-Dec-10 21:42pm

Slacker007

Updated 20-Dec-10 23:58pm

v2

Comments

Dalek Dave 21-Dec-10 4:09am

You tell him , Tiger.

#realJSOP 21-Dec-10 5:59am

From the OP: Thnks for this suggestion, I tried it already. But what i want is the restriction for numeric, date time & text field. Which i am not able to get.
I am able to enter numbers in the text field & alphabets in the numeric field which i don't want.
Any idea please let me know.

nattynids 21-Dec-10 6:05am

I am new to C# and i don't know anything about Excel. Can you explain what you are telling.

Slacker007 21-Dec-10 6:52am

@nattynids: VBA is Visual Basic for Applications. It is the programming environment for most Office programs such as Excel. It has nothing to do with C#. Google VBA and Excel and you will see thousands of examples for you to learn from. Good luck!

nattynids 22-Dec-10 4:34am

thnks.