G
Guest
Using Excel 97. I'm importing data, ASCII comma separated, that includes time in this format
hour:minute:sec.millise
For example, 07:49:03.01 is 3.01 seconds past 7:49 am
If I select 2 cells with data in this format I get a program error and excel crashes. If I select a cell and change the format to anything but Time m:s.0 the problem goes away. Trouble is, I have thousands of these cells in hundreds of data files to process. I can't select a row or a column or an entire sheet without a crash. A macro works if I use it to select cells one at a time and change the format, but slows down my processing significantly
Any ideas why this crash happens
I found it simple enough to instigate. Enter 1:2:3.4 in each of 2 adjacent cells and then select them. Crash!
hour:minute:sec.millise
For example, 07:49:03.01 is 3.01 seconds past 7:49 am
If I select 2 cells with data in this format I get a program error and excel crashes. If I select a cell and change the format to anything but Time m:s.0 the problem goes away. Trouble is, I have thousands of these cells in hundreds of data files to process. I can't select a row or a column or an entire sheet without a crash. A macro works if I use it to select cells one at a time and change the format, but slows down my processing significantly
Any ideas why this crash happens
I found it simple enough to instigate. Enter 1:2:3.4 in each of 2 adjacent cells and then select them. Crash!