Divide by 100.


If this post helps click Yes
---------------
Jacob Skaria


"gump" wrote:

I've converted a text file into excel and need to change the decimal location
of fixed data. The data I'm trying to change is 331864 to 3318.64 or 51500
to 515.00. No matter what I do I can only get 331864.00 or 51500.00. Can
anyone help