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?
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?
"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? What I mean is I only want some one to be able to enter "P3 and then one , but not more than 3 digits. For example P3 111 or P3 2, or P3 45. It is for a template for my dive spots.
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
[email protected]
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks