Hi all,
I have an Excel 2003 spreadsheet which when I open displays 2 decimals only regardless of the format that I apply to it.
However when I save it as xml it displays about 10 decimals and this appears to be the real value as it is the one that an application is validating when I process the file.
Can any one help me understand where the "real" value of this cell could be?
I have about 100 worksheets, each has an identical structure.
The area on each worksheet to be printed is small.
If these areas were moved to co-exist on the same worksheet then the number
of pages required to print everything would be a fraction of 100. (Moving
these areas onto one worksheet is not an option given other reasons for
structuring the workbook the way it is.)
Can I print all worksheets at once and use fewer than 50 double sided pages?
Many thanks,
Stephen Powell
Hi everybody,
I have a worksheet with 3 columns filtered for certain values. I am trying to filter a 4th column using the Top 10 AutoFilter to return the top (or bottom) 5 values.
The problem is that the filter only returns 2 rows of data, or sometimes none. I think I understand why this is happening (the 'top 10' refers to the unfiltered list - therefore fewer than 10 are retrieved when other filters are active?) - but I wondered if there was a way around it?
I can get the data I need by using the (Custom...) AutoFilter, and manually selecting 'Show rows where...is less than'...the 5th largest value, but I would like to automate this if possible. The macro recorder doesn't help because if I follow these steps the code shows the 5th largest value as the filter criteria, which of course will vary depending on the other filters in use.
Apologies for going on a bit (!), but this has been bugging me for a while, so any help would be most appreciated!
Cheers
Mark
p.s. I tried searching the forum but came up blank...
Hi everyone. I don't know if this can be done with or without VBA and a macro. I have a spreadsheet, attached below, which has a number of statistics and then columns with measures of success with 0s or 1s. I need to create multiple spreadsheets, each that have all of the statistics, but only one measure of success at the end. I would just copy and paste, but I need to do this for around 50 files. Any help?
Thanks!
1st workbook has around 2500 records, and the second has about 2000 records.
The records on the 2nd exist on the 1st, but have different values in 1
field. I'd like to merge the 2nd workbook's updated fields into the 1st
'master' list. Is this possible?
this is an assignment i have.. i have looked all over and tried the office
assitant and alot of things even read a manual and i couldnt find it. Thank
yo u
Hi all.
I'm running a very simple SELECT query off some Oracle tables in Access 2007. When I first run it, I get 8,237 records appear. The last one is a duplicate which, as far as I can tell, shouldn't be in the results. When I sort the results by the ID field, I only get 7,853 records, and the previously duplicated entry only appears once. I guess the operative phrase is 'what the hell...?'
If I add the 'ascending' flag to the ID field in the query builder, I still get 8,237 records, but only 7,853 if I re-sort.
Looks like a bug to me. Anyone come across this before? Any tips?
Thanks,
CSBBB.
(1) I need a formula to put in the conditional formatting function that would accept whole numbers only, NO decimal numbers.
Reason: In case tons data (with decimal places) is enter in cell where an order number is supposed go.
(2) I need a formula to put in the conditional formatting function that would accept only whole numbers that HAVE a decimal number limited to 2 decimal places.
Reason: In case order number (having no decimal places) is entered where the tons data is supposed to go AND only whole numbers with 2 decimal places to keep from errantly hitting an extra decimal place.
Thanks
I need to change the decimal format depending on the cell value.....Is it possible...?
