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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Files
Create a macro that does all the work (importing, formatting, ...) that you
want. Start a new workbook Start recording a macro in this new workbook Import your data format your data (fix the page setup, column widths, freeze panes, autofilters...) Stop recording your macro Close the data workbook. Back to the workbook with the newly recorded macro. Save this with a nice name: ImportAndFormatWeeklyData.xls Add a button from the forms toolbar to a worksheet. Assign the recorded macro to this button Add some instructions to this worksheet Save the workbook (again). Try clicking on the button to see if it works. KarenW wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Files
It worked! Thank you very much!
"Dave Peterson" wrote: Create a macro that does all the work (importing, formatting, ...) that you want. Start a new workbook Start recording a macro in this new workbook Import your data format your data (fix the page setup, column widths, freeze panes, autofilters...) Stop recording your macro Close the data workbook. Back to the workbook with the newly recorded macro. Save this with a nice name: ImportAndFormatWeeklyData.xls Add a button from the forms toolbar to a worksheet. Assign the recorded macro to this button Add some instructions to this worksheet Save the workbook (again). Try clicking on the button to see if it works. KarenW wrote: 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 -- Dave Peterson |
Reply |
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) |