Using F2 - How do you do 3,000 entries all at once?

Giganews Newsgroups
Subject: Using F2 - How do you do 3,000 entries all at once?
Posted by:  AndreaW
Date: Tue, 23 May 2006

I have discovered I need to change cell formatting from Text to General in
order to get my VLOOKUP to work properly.  The problem is is that I would
prefer to do this all at once as my column contains well over 3,000 entries.
Imagine pressing F2, Enter, F2, Enter, F2, Enter into each individual cell (I
can't keep the beat going!)  Is there a better way to perfom this task in one
step?

Replies