Text File Import Conversion Problem

[rjacmuto32]

I have a text file with dollar amounts. The problem is the amounts have no decimal places in them. For example 00015825 I brought that information into excel and I want to display it with a decimal. The last 2 digits are the decimal. so i want excel to display 158.25 How do I do that?

Thanks,
--Robert

 

[venkat1926]

tools-options-edit
check fixed decimla places and then choose 2. click ok
try this.
but after this is done you have to shift back to uncheck this item