Category Archives: microsoft

microsoft, spreadsheet

Excel – Display or hide zero values

Hide or display all zero values on a worksheet

  1. Click File > Options > Advanced.
  2. Under Display options for this worksheet, select a worksheet, and then do one of the following:
    • To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
    • To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

Hide zero values in selected cells

These steps hide zero values in selected cells by using a number format. The hidden values appear only in the formula bar and are not printed. If the value in one of these cells changes to a nonzero value, the value will be displayed in the cell, and the format of the value will be similar to the general number format.

  1. Select the cells that contain the zero (0) values that you want to hide.
  2. You can press Ctrl+1, or on the Home tab, click Format > Format Cells.

    Format Cells on the Home tab

  3. Click Number > Custom.
  4. In the Type box, type 0;-0;;@, and then click OK.

To display hidden values:

  1. Select the cells with hidden zeros.
  2. You can press Ctrl+1, or on the Home tab, click Format > Format Cells.
  3. Click Number > General to apply the default number format, and then click OK.

Hide zero values returned by a formula

  1. Select the cell that contains the zero (0) value.
  2. On the Home tab, click the arrow next to Conditional Formatting > Highlight Cells Rules Equal To.
  3. In the box on the left, type 0.
  4. In the box on the right, select Custom Format.
  5. In the Format Cells box, click the Font tab.
  6. In the Color box, select white, and then click OK.

Display zeros as blanks or dashes

Use the IF function to do this.

Data in cells A2 and A3 in an Excel worksheet

Use a formula like this to return a blank cell when the value is zero:

  • =IF(A2-A3=0,””,A2-A3)

Here’s how to read the formula. If 0 is the result of (A2-A3), don’t display 0 – display nothing (indicated by double quotes “”). If that’s not true, display the result of A2-A3. If you don’t want the cells blank but want to display something other than 0, put a dash “-“ or other character between the double quotes.

Hide zero values in a PivotTable report

  1. Click the PivotTable report.
  2. On the Analyze tab, in the PivotTable group, click the arrow next to Options, and then click Options.
  3. Click the Layout & Format tab, and then do one or more of the following:

    • Change error display     Check the For error values show check box under Format. In the box, type the value that you want to display instead of errors. To display errors as blank cells, delete any characters in the box.

    • Change empty cell display     Check the For empty cells show check box. In the box, type the value that you want to display in empty cells. To display blank cells, delete any characters in the box. To display zeros, clear the check box.

Source: Display or hide zero values

microsoft, MicrosoftSucksAss, Windows

How to Install Windows 11 Home With a Local Account – ExtremeTech

When you see the “Let’s connect you to a network” screen, hit Shift-F10, type “taskmgr” in the command prompt window, and kill the process called “Network connection flow.” According to the video, this will allow the OS to install normally after you insert a user login and password. You can also kill the application directly from the command line if you like, using the command “taskkill /F /IM oobenetworkconnectionflow.exe”

Source: How to Install Windows 11 Home With a Local Account – ExtremeTech

microsoft, MicrosoftSucksAss, Security, Software, sysadmin, Win10, Windows

“Your administrator has blocked this application because it potentially poses a security risk to your computer” 

“Your administrator has blocked this application because it potentially poses a security risk to your computer”

Issue:

During the installation of BIM 360 Glue Desktop, you see this error message:

Application Install – Security Warning
Your administrator has blocked this application because it potentially poses a security risk to your computer.

Security Warning when installing BIM 360 Glue desktop app

Causes:

The Windows ClickOnce trust prompt is disabled. ClickOnce, a component of the .NET Framework, must be enabled to run BIM 360 Glue.

Solution:

To resolve the issue, enable this registry key:

  • HKLM\SOFTWARE\MICROSOFT\.NETFramework\Security\TrustManager‌​\PromptingLevel\Inte‌​rnet

Note: This operation should be performed by an administrator with a technical understanding of the Windows Registry.

To enable the registry key:

  1. Open the registry editor:
  2. Find the following registry key:

    \HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\.NETFramework\Security\TrustManager\PromptingLevel\Internet

    If the key does not exist, create it.

  3. Set the value to Enabled.

Warning!
Problems caused by improperly editing the Windows registry could render your computer operating system unusable. Microsoft provides a wealth of critical information that you need to know about the registry in the Microsoft Knowledgebase. Use the Microsoft Registry Editor only at your own risk and only after backing up the registry as outlined for your operating system in the Microsoft article How to back up and restore the registry in Windows and in the related solution How to back up the system registry. Additional information about the registry is also contained in the Help topics in the Microsoft Registry Editor.

Source: “Your administrator has blocked this application because it potentially poses a security risk to your computer” when installing BIM 360 Glue | BIM 360 | Autodesk Knowledge Network

microsoft, MicrosoftSucksAss, Win10, Windows

How To Install Windows Apps Without a Microsoft Account – CCM

How To Install Windows Apps Without a Local Account

  • Right-click on the Start menu to display your Power User options. Select the Run command. Next, type in 
    regedit

    followed by Enter to open the Registry Editor:

  • Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System.
  • Click on the Edit menu, followed by New > DWORD (32-bit) Value. Rename the new key as MSAOptional:

  • Set the value of MSAOptional to 1. This will make your Microsoft accounts optional:

  • Close the Registry Editor and restart your computer. Once your computer loads, open the Windows Store and search for your desired app. Skip the sign-up procedure and proceed directly to your download.

Source: How To Install Windows Apps Without a Microsoft Account – CCM