Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formatting assumptions
This may seem like a wacky question. But in the past, we have seen where
Excel will ignore formatting or mess it up. What I mean by that, for example, is when we had an Income column and the first few rows had no Income data, we actually had to manually input a "0" into these rows. Otherwise we found that the formatting in Excel messed us up; especially when we then turned around to try and process this Excel spreadsheet through DTS. Now, it seems as though we're experiencing the same issue with a Date field. We have a report that creates an Excel spreadsheet with A Date. The first couple of hundred rows has no date in them. Then there is a date. When we then try to import this Excel spreadsheet into a 3rd party application which allows for Excel import, it does not seem to be respecting the date and it is not importing. We are wondering if anyone else has seen this kind of anomaly in Excel and if there is any kind of solution. We appreciate your time to review and Thank You in advannce for a reply. PSULionRTP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Footnoting Assumptions | Charts and Charting in Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |