Convert Zero automatically to Nil in Excel

 If there is zero automatically show it as Nil in Excel using custom formatting.

  • Select cells
  • Right click
  • Format Cells
  • Custom
  • Paste below code in the Type box
0;-0;"Nil";@

Watch full video to know more:


Popular posts from this blog

Formula to Get Country Flags in Google Sheets

Image
I have created a formula to insert country flags in Google Sheets's cells. For this I've used IMAGE, IMPORTXML and SUBSTITUTE functions. In this formula we're taking flag images from Wikipedia.   You can paste below formula in your Google Sheets: =IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(A2," ","_")&"' )]"))  Change A2 with the cell address in which you are typing country name. You need to type first letter of country name in capital letter in order this to work. I have explained this formula in my below YouTube video. You can watch this video to understand how it works:
Read more

Steps to Turn On Offline Access for Google Docs, Sheets and Slides

Image
You aren't connected to the Internet but still want to work on Google Docs files? Then follow below steps to create, edit or view Google Docs, Sheets and Slides files while you're offline. Connect to the internet. Open or Install Google Chrome browser. Install Google Docs Offline Chrome extension. ( Click Here to Open Install Page ) Open Google Drive Click on Settings Check the box next to "Create, open, and edit your recent Google Docs, Sheets, and Slides files on this device while offline. Done Now you can click on File menu of any Google Docs, Sheets and Slides file and click Make available offline to use that file offline. Alternatively, you can right click on files in Google Drive and then click on Available offline. Watch detailed video on this:
Read more