I am trying to change the format in cells within in an excel 2003 document I've exported from our database. When I highlight the cells, go to Format cells- and select my custom format and click Okay- the new formatting is not applied. However, when I double click in each cell that I've tried to change, the new format is applied. How do I get the new formatting to work without having to double click in each individual cell? Thanks!

Posted 8 years ago