Not just odd numbers, but an odd issue.
24
5
23
6
024
022
024
012
024
I'm importing some numbers in Excel from an export from some mainframe legacy system. The numbers originally come into Excel with no specific format. I change the format to number but the numbers do not change. If i select the cell and click into the number like I'm going to edit it, exit the cell, the number will then change to the format I selected. The first 4 numbers above are how I would like them to display and the last 5 are how they come into Excel. I format the entire column to number but they do not change until I click into the number as if I'm going to edit it.
Hopefully this makes sense, I really don't have time to manually edit 5000 numbers just to get the format to work. I'm using Excel 2003.
Thanks, Brian
24
5
23
6
024
022
024
012
024
I'm importing some numbers in Excel from an export from some mainframe legacy system. The numbers originally come into Excel with no specific format. I change the format to number but the numbers do not change. If i select the cell and click into the number like I'm going to edit it, exit the cell, the number will then change to the format I selected. The first 4 numbers above are how I would like them to display and the last 5 are how they come into Excel. I format the entire column to number but they do not change until I click into the number as if I'm going to edit it.
Hopefully this makes sense, I really don't have time to manually edit 5000 numbers just to get the format to work. I'm using Excel 2003.
Thanks, Brian