Some Accounting systems (I think SAP is one) downloads negative values with a trailing minus sign. Excel doesn’t recognise this as a number. When you import TXT files, negatives are handled correctly. CSV files don’t.
The Happiest Refugee
This book has it all, humour, drama, intrigue, family secrets and running jokes throughout.
Plus its all true. Anh is a nice guy and a great comedian and he writes well. I didn’t realise he had done so some many things, and done them successfully. It shows the impact of a new country on refugees. A great read!
I heard it might be made into a movie – look forward to it.
I found a good shortcut today to increase the decimal places.
Alt H 0
For example you might use these two shortcuts one after the other to format a range as a percentage with one decimal place.
Ctrl + Shift + %
Alt H 0
A must read.
It will get you thinking about how we have progressed and whether it has been progress or regress. Have the lives of sapiens improved over the thousands of years?
What about the planet and the other animals on the planet, (the ones we haven’t killed off any way) are they better off?
Making Subtotals Bold
When you use the SUBTOTAL feature in the Data ribbon tab it automatically inserts subtotals in your list – see blog post on it here.
One problem with this is that is only makes the cell with the word Total bold – it doesn’t make the whole row bold.
If you want the whole row to be bold it isn’t hard to fix.
I use Alt key shortcuts a lot when I am working and I have found a couple more useful ones.
“Without any announcement, latest #powerbi desktop fixed time intelligence for non-contiguous selection of dates in #dax”
Printing Separate Print Areas
If you need to print a number of separate print areas from the one worksheet in one step there is an option that allows you to create a print area that includes additional ranges.
Create your first print area as per normal.
Select another print range and click the Page Layout ribbon and use the Print Area drop down and choose Add to Print Area. Keep adding ranges as you require.
You can also use the Ctrl key and mouse to select multiple separate ranges and then use Set Print Area.
The above technique allows you to add to that Print Area if you miss a range.
The only problem with this option is that each separate range is printed on a separate page(s).