How do I refresh a column after changing the formatting?

  • Thread starter Thread starter Angie
  • Start date Start date
A

Angie

I import a lot of data from different sources into excel. When I format a
column the cell does not refresh automatically. I have to manually enter the
cell and hit F2 for the formatting to take. When I am dealing with thousands
of rows, this is impossible to to. Is there a trick I don't know about that
can help me?

For example, one source might import a social security number in text format
with dashes (999-99-9999) while another will import it as a number
(999999999). I have the same problem with dates.

If anyone else has experience this problem, your advice would be appreciated.
 
Very possible that your numbers are coming in as text so formatting won't take
until you F2 and Enter.

Format all to General then......................

Select an empty cell and copy it.

Select the range to change and in place Edit>Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP
 

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

Refresh - F2 1
Formatting text form fields 3
Conditional Formatting from a group 6
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Refresh columns not in query 1
my formated column is displaying one cell incorrectly 2
Formatting not updating upon data connection refresh 0
#Num! Error in Link to Excel 1

Back
Top