View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lizette Koehler Lizette Koehler is offline
external usenet poster
 
Posts: 6
Default 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