• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

Excel 2010 Date Format

I have many cells which are in a text format of July 15, 2008.  I have updated the cell format to that of date so that it will read as 7/15/2008.  However, this update is not reflected in the cell until I "click in" the cell itself (F2).  This is frustrating as I need to have this update show for thousands of cells.  How do I get excel to see this format change?
0
rgarzakavo
Asked:
rgarzakavo
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

what does the formula bar show before you hit F2? Is it really a date? Can you post a screenshot of your file with the active cell on one of the misbehaving cells and showing the formula bar?

I'm asking for a screenshot, since differences in regional settings will make the troubleshooting more difficult with an actual Excel file.

cheers, teylyn
0
 
rgarzakavoAuthor Commented:
Screen shot attached
Screen-Shot.png
0
 
Neil RussellTechnical Development LeadCommented:
Do you have auto recalc turned off for the worksheet by anychance?
0
 
barry houdiniCommented:
Try selecting column I and using

Data > Text to columns > Finish

that should convert for you

regards, barry
0
 
rgarzakavoAuthor Commented:
Awesome!  Thnx.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now