Copying from bank statement, issue with all the date copying to a single cell and not into individual cells. The tedious workaround was to copy into MS Word and add a semicolon (or other) after each cell data. Then copy the date to Excel then:
Data > Text To Columns > Delimited > ; > Finish
I found this here
After reinstalling Windows on to my PC I noticed that I could not get Sage Line 50 2009 accounting software to load up sample or company data files. After searching I found that there is an issue related to the Windows 10 Anniversary updates. The fix is simple luckily, head over to Ask Sage and…
Got this error when trying the windows performance test. Found solution here youtube link delete MSVCR100.dll from windows/system32/ download http://www.microsoft.com/en-us/download/details.aspx?id=5555 and http://www.ascentive.com/support/new/libraryfiles.exe Edit: That did not actually work for me so I just downloaded the dll file and copied it to the folder directly: http://www.dll-files.com/dllindex/dll-files.shtml?msvcr100
I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records. I found this simple method: To modify a workbook you have to save it so we can use the before_save event ALT+F11 to open vb editor. Double click ‘ThisWorkbook’ and paste this…
I had some issues with Kaspersky AV and Outlook 2010. I launched Outlook in safe mode by holding ctrl and then launching Outlook – didn’t solve my issue but something new for me.
Using Outlook 2016 in Office 365 I kept gettingthe error: you do not have the permission required to access the file outlook pst I was logged in as admin and was using Outlook just fine but once this error appeared I could not read e-mails or do anything with Outlook. Restarting Outlook did not help,…
I had an issue with the Astra wordpress theme and my Woocommerce store pages. I was stuck with a sidebar that I wasn’t using. Astra sent me the following code to remove the sidebar: add_filter( ‘astra_page_layout’, ‘no_sidebar_shop_page’ ); function no_sidebar_shop_page( $sidebar ) { if ( is_shop() ) { $sidebar = ‘no-sidebar’; } return $sidebar; }…