Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a list of start times that need to be converted to 24 hour format. I changed the format for the entire column, but i have to press Enter for every row for excel to apply the new format.

Is there a was i can force excel to evaluate the cell format and change it. I have few thousand rows.

enter image description here

share|improve this question

migrated from stackoverflow.com Jun 20 '11 at 2:33

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 5 down vote accepted

Yes, it bugs me too.

dim c as range
for each c in application.intersect(activesheet.usedrange, activesheet.columns("C"))
  c.value = c.value
next
share|improve this answer
    
that worked great! –  vpets Jun 20 '11 at 1:30
    
you're right, none of the usual methods work. –  Lance Roberts Jun 20 '11 at 23:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.