LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default Formatting with imported data

Hi all,
I have imported data into Excel 07 from Access 02/03. There are 2 things I
would like to change.

1. The formatting that imports with the data changes the colour of the Excel
cells.

2. Headings are imported automatically with the data, and I would like the
option of changing this. These headings are dropdowns that allow sorting
choices.

Basically I need the data to import with no headings, and no formatting at
all.

Any help appreciated,
Connie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Imported Data Fabs New Users to Excel 2 September 4th 09 01:25 PM
Formatting imported data [email protected] Excel Worksheet Functions 0 May 16th 08 02:43 PM
Formatting Imported Data JpaulT Excel Discussion (Misc queries) 1 September 13th 07 05:18 PM
Formatting time from imported data Wanna Learn Excel Discussion (Misc queries) 3 June 15th 07 07:52 PM
Formatting imported data Jsb Excel Worksheet Functions 8 March 26th 06 11:48 PM


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"