How come I need to enter a cell in order for the formatting to apply correctly???

  • Thread starter Thread starter GRHyman
  • Start date Start date
G

GRHyman

I am pulling data from a database into Excel. I have a column with
over 1000 rows with dates in Excel numerical format. However, in order
to get them to be viewed as the dates after formatting the column, I
have to go into each cell (either double clicking into the cell or just
hitting F2) and then hit enter for it to be able to show the date. How
can I get this information to show up correctly the first time without
having to go into each individual cell (all 1000 of them)???
 
Probably came in as Text format.

Select the column and Data>Text to Columns>Next>Next>Column Data Format>Date.

Select a format from the Date dialog box and Finish.


Gord Dibben MS Excel MVP
 
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

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Date Formating Problem 1
Cell requires double click to 'activate' date format change 3
converting text cell to numeric cell 5
CELL ORDER 1
Conditional formatting in Excel 2010 2
Numbers showing Up Centered in Cell ? 1
conditional formatting date and blank cell 3

Back
Top