midsession
Board Regular
- Joined
- Oct 12, 2006
- Messages
- 70
Hello MrExcel
I am importing tables via WebQuery where some columns contain data separated by a colon. I can split the data using TextToColumns, but I can't get the worksheet to display the data 'as is' -it insists on treating it as a time. For instance ...
If I import 0:3 worksheet displays 12 and 3
If I import 13:3 worksheet displays 1 and 3
Worse than that, when I record a macro, the split and copy seems to work fine. When I rerun the macro it reverts to reading 17:06 as 5 and 06!
Can anyone help?
I am importing tables via WebQuery where some columns contain data separated by a colon. I can split the data using TextToColumns, but I can't get the worksheet to display the data 'as is' -it insists on treating it as a time. For instance ...
If I import 0:3 worksheet displays 12 and 3
If I import 13:3 worksheet displays 1 and 3
Worse than that, when I record a macro, the split and copy seems to work fine. When I rerun the macro it reverts to reading 17:06 as 5 and 06!
Can anyone help?