Validating Cells...

[selraith]

Hi is it possible of validating cells so that the a row of cells such as f12 to f84 can only enter either package 1 package 2 package 3 pacakage 4 pacakge 5 pacakage 6 pacakage 7 pacakage 8 or pacakage 9?

also is it possible to have cells from g12 to g84 to only have numbers and j12 to j84 to only have currency???!?!?

And finally D12 to d84 only to have text?

Im sorry if im asking to much its just so that the topics dont duplicate .....

Thanks in advance and as always drinks on me... :beerchug:

[Bob Phillips]

Hi is it possible of validating cells so that the a row of cells such as f12 to f84 can only enter either package 1 package 2 package 3 pacakage 4 pacakge 5 pacakage 6 pacakage 7 pacakage 8 or pacakage 9?

DV with a formula of

=AND(LEFT(F12,8)="Package ",ISNUMBER(--RIGHT(F12,LEN(F12)-8)))


also is it possible to have cells from g12 to g84 to only have numbers and j12 to j84 to only have currency???!?!?

Numbers, DV with allowable numbers

[mikerickson]

Look under Validation.

package 1, package 2, ..., package 9 sounds like a list would be best for that.

currency vs numbers? Excel doesn't recognize the difference. If a cell is formatted as currency, Excel shows a dollar sign in front of the number, but looks at the cell as containing a number.

Text Only? Yes but the string "1" is text. Do you want it to allow "A-1 Carpet Cleaners"?

[unmarkedhelicopter]

Excel shows a dollar sign in front of the number, but looks at the cell as containing a number.That entirely depends on what country you are in and what currency symbol you have selected and its format.

[Bob Phillips]

You're forgetting that US Americans don't realise there are countries different to theirs.

[selraith]

You're forgetting that US Americans don't realise there are countries different to theirs.

lol its the british pounds ?
thats the currency im after for it

[Bob Phillips]

The point is still that the currency symbol usually is not part of the data, it is just a visual layer on top o the underlying value. You could test the numberformat in VBA, but seems overkill.