Scarlet_Buckeye
Posts: 5,264
Nov 15, 2010 11:28am
I want to lock a cell so that the only data that can be entered into the cell is of dollar or date value. For instance, I want users to be able to enter " $11.61 " or " $900,200.99, " but not " cat " or " book."
Same thing for date fields... I want users to be able to input " 03/12/2001, " but not " March " or " scrabble. "
I've found out how to lock cells, but I don't want to lock it so that the next user can't input any information. I just want to lock it so that their input values are limited.
Thanks
Same thing for date fields... I want users to be able to input " 03/12/2001, " but not " March " or " scrabble. "
I've found out how to lock cells, but I don't want to lock it so that the next user can't input any information. I just want to lock it so that their input values are limited.
Thanks
FatHobbit
Posts: 8,651
Nov 15, 2010 11:36am
Can you try using validation? (It's under data in my version.)
Scarlet_Buckeye
Posts: 5,264
Nov 15, 2010 11:39am
FatHobbit;559192 wrote:Can you try using validation? (It's under data in my version.)
Thank you. That did the trick. In 2007, Data --> Data Validation (for those also interested)
FatHobbit
Posts: 8,651
Nov 15, 2010 11:42am
Scarlet_Buckeye;559194 wrote:Thank you. That did the trick. In 2007, Data --> Data Validation (for those also interested)
I'm using excel 2003. Lol. Nothing like being 7 years behind with technology.
OneBuckeye
Posts: 5,888
Nov 15, 2010 11:53am
FatHobbit;559196 wrote:I'm using excel 2003. Lol. Nothing like being 7 years behind with technology.
OT, but I am getting a new laptop for work and IT guy calls me and asks me what software I need ect. Anyway, I ask him what version of office he is giving me and he says 2003. I upgraded from 2003 to 2007 on my current laptop, why woudln't they give everyone the new version. SMH
M
MontyBrunswick
Nov 15, 2010 1:45pm
Most people would actually prefer 2003 over 2007. There's some mad hate for that new interface.
gorocks99
Posts: 10,760
Nov 15, 2010 1:46pm
2010 works better than 2007; I was pissed w/ the ribbon in 07 (longtime 03 user) but am used to it in 2010 now, plus they worked out some bugs.
lhslep134
Posts: 9,774
Nov 15, 2010 1:50pm
I use 2007 and have no issues with it. If I really can't find something, I just use the help.
Scarlet_Buckeye
Posts: 5,264
Nov 15, 2010 4:53pm
dlazz;559341 wrote:Most people would actually prefer 2003 over 2007. There's some mad hate for that new interface.
2007 > 2003
Go_Fast_Sports
Posts: 390
Nov 15, 2010 5:47pm
Microsoft created 2010 because 2007 had patent issue violations, plus it fixed the bugs in 2007. 2010 blows 2007 away! But then again... it empties your wallet too.
Just like how Microsoft created Windows 7 because of all the Vista issues and bugs.
Just like how Microsoft created Windows 7 because of all the Vista issues and bugs.
Pick6
Posts: 14,946
Nov 15, 2010 11:30pm
i got everything 2010 for 80 bucksGo_Fast_Sports;559699 wrote:Microsoft created 2010 because 2007 had patent issue violations, plus it fixed the bugs in 2007. 2010 blows 2007 away! But then again... it empties your wallet too.
Just like how Microsoft created Windows 7 because of all the Vista issues and bugs.
M
MontyBrunswick
Nov 16, 2010 12:20am
Scarlet_Buckeye;559617 wrote:2007 > 2003
I'm indifferent between the two. 2010 is OK.
sleeper
Posts: 27,879
Nov 16, 2010 12:35am
I've been using 2003 on my PC and 2008 for my MAC. I really don't like 2008 for the MAC, its goofy.
Go_Fast_Sports
Posts: 390
Nov 16, 2010 12:51am
Pick6;560258 wrote:i got everything 2010 for 80 bucks
What school did you get it from?
ernest_t_bass
Posts: 24,984
Nov 16, 2010 8:38am
HAHA... Cat.
OneBuckeye
Posts: 5,888
Nov 16, 2010 8:40am
2003 is unusable for me because of the row limit. That is the primary reason 2007 and 2010 are far superior.