Thread: Text Files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KarenW KarenW is offline
external usenet poster
 
Posts: 4
Default Text Files

I am importing a comma-delimited text file. I need to format one column in
the file to show as currency. What is the best way to do this so when the
file is imported weekly it automatically convert that column?

Examples:
10633 needs to show as 106.33
850 needs to show as 8.50
4914 needs to show aw 49.14