RaunLGoode
Registered User.
- Local time
- Today, 09:02
- Joined
- Feb 18, 2004
- Messages
- 122
I need to import SAP data in an HTML file into Excel, but there seems to be a data type issue.
When I select a cell I get the value of the numbers in the cell, but if I try to use the cells in a calculation, or try to Sum etc. the cells, I get a value of zero or the "#VALUE!" error. The Data comes in as "General" type
If I hand enter the value of a cell it works fine. I tried to use Format Cell to change data types with no luck. I also tried to Copy >Paste Special , also with no luck.
My two questions are:
1) What is causing this problem?
2) How can/should I modify the data into a usable data type?
When I select a cell I get the value of the numbers in the cell, but if I try to use the cells in a calculation, or try to Sum etc. the cells, I get a value of zero or the "#VALUE!" error. The Data comes in as "General" type
If I hand enter the value of a cell it works fine. I tried to use Format Cell to change data types with no luck. I also tried to Copy >Paste Special , also with no luck.
My two questions are:
1) What is causing this problem?
2) How can/should I modify the data into a usable data type?