(Msg. 1) Posted: Mon Oct 12, 2009 1:19 pm
Post subject: Enforce format Archived from groups: microsoft>public>excel>newusers (more info?)
How can I "enforce" a format in a cell in excel so that it allows number
entry only, i.e. it does not allow letters or any other characters.
Thanks in advance.
Keith
(Msg. 2) Posted: Mon Oct 12, 2009 4:28 pm
Post subject: Re: Enforce format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Data Validation; custom formula; If active cell is A1, use this:
=NOT(ISERROR(1*A1))
"Elfey1001" <Elfey1001.RemoveThis@discussions.microsoft.com> wrote in message
news:D744EEFC-3BD0-43A7-B673-F16107BBFA03@microsoft.com...
> How can I "enforce" a format in a cell in excel so that it allows number
> entry only, i.e. it does not allow letters or any other characters.
> Thanks in advance.
> Keith
(Msg. 3) Posted: Thu Oct 15, 2009 9:55 am
Post subject: RE: Enforce format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
In EXCEL 2007:-
Data / Data Tools / Data Validation / Data Validation / Settings tab /
Allow: field - in here you can do what you want plus a variety of other
options.
If my comments have helped please hit Yes.
Thanks!
"Elfey1001" wrote:
> How can I "enforce" a format in a cell in excel so that it allows number
> entry only, i.e. it does not allow letters or any other characters.
> Thanks in advance.
> Keith
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office