Format not Really What It Pretends to Be

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I download or import into Excel, I often have columns that aren’t really
in the format they should be in. For instance, you can format a column as a
date and the numbers look like a date, but you can’t sort or do a VLookup on
the field. The only way I can get Excel to recognize the column as a date
(or number, or whatever) is to F2 and enter through each cell in the column.
This is OK with a sheet that is 10 – 20 rows long, but I’m working with
files that are thousands of rows long, and having to F2 and enter through
each cell is too much.

Does anyone have any idea how to shorten this process?
 
Usually works if you copy a blank cell, select the offending data, and use
Edit->Paste Special->Add
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function to return date content of another cell 7
Using Dates in Conditional Formatting 9
SUMIFS help 3
How to Convert 24/03/2010 as text into 03/24/2010 date format 2
Multiple Conditional tests with Sumproduct 6
Extract "Does not equal" data 4
Format row using date 5
returning a text value using a formula 1

Back
Top