Problems with HTML-import

J

Jakob Juul

When I import data from an HTML-file the values is not
numeric but text. It is shown with a little green sign
upper left i a cell.

Has anyone a suggestion why this is happening cause I
di´n´t have the problem in Office 97?
 
D

Dave Peterson

Are you concerned with the little green sign?

If yes, it's excel 2002's way of showing you that something appears wrong. If
you select the cell, you'll see a little "caution" icon near your cell.

Click on it and you'll see what excel is warning you about. xl will even give
you a chance to convert the text number to number number.

If you hate this symbol, you can turn it off (or portions of the checking) via:
Tools|Options|Error Checking Tab

Turn it all off or just disable the checks for the rules you like to break.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top