Thread
:
Is there a way to only have certain things typed into a cell?
View Single Post
#
3
Posted to microsoft.public.excel.misc
paul
Posts: n/a
Is there a way to only have certain things typed into a cell?
you could have data validation set in say cell A1 to allow whole numbers
between 1 and 999,and in another cell type ="p3"&a1
--
paul
remove nospam for email addy!
"Big Abalone" wrote:
Is it possible to have only "P3 000" the "0" means any digets, not more than
3 tho. be the only thing able to be entered?
Reply With Quote