Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (xls) files spontaneously converting to text files | Excel Discussion (Misc queries) | |||
Text Files | Excel Discussion (Misc queries) | |||
how do i convert text files into CSV files? | Excel Discussion (Misc queries) | |||
convert files to text | Excel Discussion (Misc queries) | |||
Importing text-files | Excel Discussion (Misc queries) |