Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I clean old excel data format with macro on funny spread sheet
I need to clean up data in excel files coming out of report writer.
It is a simple flat file with some unusual formats so I believe simple wacking all formats is not a good choice - lots of funny time and date stuff. Also some of the reports are 30 columns wide - lots of formats. it is dumping as an excel 3.0 but i say no to formats (report formats) My pivots keep seeing this database for range even after I overide - it always goes back to the old format database and i have to keep rehighlighting my data getting old - doing many pivots thanks for any comments |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to clean up data | Excel Discussion (Misc queries) | |||
help wanted to clean up a data sheet | Excel Discussion (Misc queries) | |||
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions |