Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy paste SQL query result to excel spreadsheet with formatting
How can I copy paste a SQL query result to an Excel spreadsheet without the
formatting of certain columns like(date, currency) getting affected? Right now, I just use the copy-paste function and then I have to individually select each date and currency column on the excel spreadhseet and change the format. It's a labour intensive process when I have more than 20 columns to format seperately and more than 100 spreadsheets. Please let me know if there's a better way to go about it. Thanks for reading! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you copy and paste row height formatting in excel | Excel Discussion (Misc queries) | |||
Query, copy & paste | Excel Discussion (Misc queries) | |||
copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
How to preserve conditional formatting on a web query table result | Excel Discussion (Misc queries) |