Programing Cell

[brutus0616]

please could anybody tell me..how format or programing any cell for only accept numeric value and not alphanumeric value.

Thank's

[Richard Schollar]

Well, you could use Data>Validation with Allow of either Whole Number or Decimal depending on your needs.

[Carim]

Hi,

Use Data Validation
Allow Custom
Formula

Please Login or Register  to view this content.

[brutus0616]

ok..but can't use two validations in the same cell or not?

[Carim]

But ...why ... and what do you mean by two validation formulae ...?

[brutus0616]

But ...why ... and what do you mean by two validation formulae ...?

ok.. firts validation is for tex (lenght of field tex) and second ( don't accept *, - / $ or any alphanumeric caracter).

[Carim]

Hi,

You can use in the Validation formula ...

Please Login or Register  to view this content.

[brutus0616]

Hi,

You can use in the Validation formula ...

Please Login or Register  to view this content.

this code if for use in the same cell or need create any macro..thank's

[brutus0616]

this code if for use in the same cell or need create any macro..thank's

sorry forget ...this code need to accept value zero before any number

[Carim]

Hi,

For your information, if your input is 0123 ... this input is not a number but a text ... !!!

[Carim]

You could try following ...

Please Login or Register  to view this content.

[brutus0616]

You could try following ...

Please Login or Register  to view this content.

Carim ..after put code excel retum error "You may not use unions, intersections, or array constants for data validations criteria"...

[Carim]

Hi,

An event macro does it for you ...only text made of numbered characters ...