Your are viewing a read-only archive of the old DiS boards. Please hit the Community button above to engage with the DiS !
post excel queries here, and someone might be able to help.
but it was just to get people to use it draaw a meat and balls
when you are resizing columns you can double click on the line and it does it automatically but if you try to do it for rows then if there are merged cells anywhere near it is fucking shit
You've never done one of those quizzes? 90s strikers, Toys of your Childhood, fox parts etc
Someone post some here
I had no idea. I avopid anything that ends in xls or whatever. Scary.
as a white page with lots of rectangles.
Oddly, I've just been sent a spreadsheet. I damn well refuse to open it though.
and then that macro will repeat those actions in a systematic way. so if you have a long boring manual bit off manipulation to do you just record it the first time and then it will do it for you. sort of
plus no one here knows what they are so it makes me look good.
like you can on word?
next column along, "=proper(cell name)". Then copy and paste special over original text.
When doing a mail merge, and trying to insert monetary data into the email/letter in Word drawn from an Excel doc, why does it screw up the numbers after the decimal point when it appears fine in excel?
E.g. - In Excel the amount appears as £74.89, but when it appears in the merged document it comes up as £74.9. Or if the number ends in zero it misses off the zero. Or if the number is a fraction and excel rounds it up/down, why does the initial un-rounded fraction appear in the merged document?
It's infuriating, anyone able to help?
and sepcifying how many decimal bits you want. that might help
and also done what alcxxk suggests below re: formatting in word with not much luck. Our tech person thinks it's a problem with Excel, which was why I asked...
use the TEXT function in excel to convert the amounts to text in the correct format, then word shouldn't mess with them.
where A1 has the amount in and £#,##0.00 is the format (which you can see if you go to the Custom category in Format Cells > Number)
(dunno if this would work, i've never done a mail merge)
i was starting this thread to ask a question, realised that the answer was just "duh, do a sum in a pivot table you idiot" but i started the thread for you all. it's my gift to the boards
monkey around a bit
formatted to number and to text, and it still does it.
It's just occurred to me, though, that it's probably something in AutoFormat.
either should work
are you changing like, cells that you've already done? did you change the whole column (or row) to number and then it was still making them show as dates?
but it was just in one cell. So far as I know it wasn't happening in any other cells. Either that, or it was that particular number.
From memory, I would enter the number, it would autoformat to date, then I select the cell (not row or column) and try to format cell as number or text, and nowt would happen.
Anyway, don't give it any more thought. I hate excel and knowing how to fix that problem won't stop me hating it. Call it my pig-ignorant prejudice.
WARN TO THREAD
WARN TO THREAD
Just finished a lovely nested IF statement with lots of matching and offsetting. Works a treat.
You know I appreciated it really.
Should be clearer then.
Someone might get it
The number of potential packages for each contractor and the information on those packages.
I wanted the total count of package names and I wanted a count of how many cells had information in them to show what % of packages we had information on. however when I tried to filter the blank cells it applied that filter to both counts and reduced both fields when I wanted it to just filter the 2nd
Contractor Potential Packages Tracked packages % tracked
Bumsnoggers 240 24 10%
What I got:
Contractor Potential Packages Tracked package %tracked
Bumsnoggers 24 24 100%
under the correct heading that'd be great.
that compares the values in a column of cells against the values in another column of cells and makes sure they are greater - depending on whether another cell has a certain value or not. cheers
do the relevant if calcs and auto filters then end record.
Now add the macro to an icon on the menu bar. I have a macro that basically does this.
for each cell in range("Ivegotreallybadarseitch")
if cell [list of itchycriteria] then
elseif this isn't what you wanted then
cock off my flaps
Colnum = 1
Colnum = 2
NumRows = 100
For i = 1 to NumRows
If Cells(colnum,i) > Cells(Colnum2) then
'Do Something if greater
'Do something if smaller
Colnum2 = 2 second line
Sometimes when I double click on a cell to edit it, it suddenly throws me about halfway down the page to another random cell and I completely lose where I was. I hate this and would love to know how to stop it from happening.
- Terry, Clitheroe
Shut excel and start again.
(or don't double click it and just click it once then in the top task bar bit and see whaddup with it. Might have a lot of spaces in it or something and its not wrapped)
afaik you can only turn it off by turning off cell drag+dropping by going to: Tools > Options > Edit tab > untick 'Allow cell drag and drop'. (prob depends what version of excel you're using)
just make a macro? can i do this for work and you can't edit the software?!
then alt h v v
right click a toolbar, select Customize..., go to Commands, select Edit, scroll down the right hand list, find Paste Values, drag it to where you want the button to go.
Then Visual Basic.