View Single Post
  #1   Report Post  
wal50
 
Posts: n/a
Default Text to Currency

I have several files to import. They are .txt files where the dollar amount,
in addition to being text, has an implied decimal point (198756 should be
$1987.86). I can import and format the other fields (dates, etc) using the
wizard. How can the text/implied decimal be handled? Also, how can lead
zeros be retained in a numeric format?
Thanks
wal50