Pre-format your cells as "Text", then enter your data.

Select your range of cells
From the Format Menu, choose "Cells..."
On the Number Tab, choose "Text"
Click OK

Now, anything you type in those cells will be treated "as is".

HTH,
Elkar


"Lizette Koehler" wrote:

I am trying to load a worksheet with a Table I created in Word.

One column contains Hexidecimal-like data. It has 300E or B34F and so on.
When it gets a field that contains an E it changes it to Scientifc Notation.
I need it to remain as is.

So when it sees 3E04 I need 3E04 not 3.00+E4

I have been rumaging through the help panels and other resources and cannot
seem to find a way to prevent it from changing this field to what it thinks
it is. I can be considered ASIS data and not a number.
--
Lizette Koehler