Hi All,

I have imported a CSV file into Excel as Text.
The Text Format in question is a column showing: 8.30
I want the Column to show 08.30
What I have done is formate Column to Custom 00.00

The data in the Column does not refresh, unless I double click in each cell.
Is there another way to refresh this data as a whole sheet or a column?