View Single Post
  #1   Report Post  
Law
 
Posts: n/a
Default I need help insert a decimal other then directly to the right of t

I am importing a text file in to Excel. The data for the amount filed does
not include the decimal place. So I need to insert the decimal into the
number. For example the data is

1234

I want to insert the decimal right in the middle as

12.34

I would greatly appreciate anyones help on this.