Prevent Formatting of a Cell when it is loaded
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
|