Ohio Chatter
Ohio Chatter

Forums

All Threads Serious Business Sports Politics Archive Pick 'ems
Log In Create Account

Microsoft Excel help

Home ▸ Archive ▸ Serious Business ▸ Microsoft Excel help
Scarlet_Buckeye's avatar

Scarlet_Buckeye

Senior Member

5,264 posts
Nov 15, 2010 11:28 AM
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
Nov 15, 2010 11:28am
FatHobbit's avatar

FatHobbit

Senior Member

8,651 posts
Nov 15, 2010 11:36 AM
Can you try using validation? (It's under data in my version.)
Nov 15, 2010 11:36am
Scarlet_Buckeye's avatar

Scarlet_Buckeye

Senior Member

5,264 posts
Nov 15, 2010 11:39 AM
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)
Nov 15, 2010 11:39am
FatHobbit's avatar

FatHobbit

Senior Member

8,651 posts
Nov 15, 2010 11:42 AM
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.
Nov 15, 2010 11:42am
OneBuckeye's avatar

OneBuckeye

Senior Member

5,888 posts
Nov 15, 2010 11:53 AM
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
Nov 15, 2010 11:53am
M

MontyBrunswick

Nov 15, 2010 1:45 PM
Most people would actually prefer 2003 over 2007. There's some mad hate for that new interface.
Nov 15, 2010 1:45pm
gorocks99's avatar

gorocks99

Senior Member

10,760 posts
Nov 15, 2010 1:46 PM
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.
Nov 15, 2010 1:46pm
lhslep134's avatar

lhslep134

why so serious?

9,774 posts
Nov 15, 2010 1:50 PM
I use 2007 and have no issues with it. If I really can't find something, I just use the help.
Nov 15, 2010 1:50pm
Scarlet_Buckeye's avatar

Scarlet_Buckeye

Senior Member

5,264 posts
Nov 15, 2010 4:53 PM
dlazz;559341 wrote:Most people would actually prefer 2003 over 2007. There's some mad hate for that new interface.

2007 > 2003
Nov 15, 2010 4:53pm
Go_Fast_Sports's avatar

Go_Fast_Sports

Senior Member

390 posts
Nov 15, 2010 5:47 PM
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.
Nov 15, 2010 5:47pm
Pick6's avatar

Pick6

A USA American

14,946 posts
Nov 15, 2010 11:30 PM
Go_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.
i got everything 2010 for 80 bucks
Nov 15, 2010 11:30pm
M

MontyBrunswick

Nov 16, 2010 12:20 AM
Scarlet_Buckeye;559617 wrote:2007 > 2003

I'm indifferent between the two. 2010 is OK.
Nov 16, 2010 12:20am
sleeper's avatar

sleeper

Legend

27,879 posts
Nov 16, 2010 12:35 AM
I've been using 2003 on my PC and 2008 for my MAC. I really don't like 2008 for the MAC, its goofy.
Nov 16, 2010 12:35am
Go_Fast_Sports's avatar

Go_Fast_Sports

Senior Member

390 posts
Nov 16, 2010 12:51 AM
Pick6;560258 wrote:i got everything 2010 for 80 bucks

What school did you get it from? ;)
Nov 16, 2010 12:51am
ernest_t_bass's avatar

ernest_t_bass

12th Son of the Lama

24,984 posts
Nov 16, 2010 8:38 AM
HAHA... Cat.
Nov 16, 2010 8:38am
OneBuckeye's avatar

OneBuckeye

Senior Member

5,888 posts
Nov 16, 2010 8:40 AM
2003 is unusable for me because of the row limit. That is the primary reason 2007 and 2010 are far superior.
Nov 16, 2010 8:40am