How to show a value in Millions in Excel

 In Excel, when are designing a dashboard with big figures like  number which runs into Millions. Its not a good idea to show all the digits in the cell as this might make the dashboard look very busy and doesn't make any sense to the executives who would review it.

In these cases you can use the "Custom" Format to mask the value into showing in millions. As shown above enter "#0.0,, "M" without quotes and the value will be shown in Millions. Observe the formula bar the value is not modified but the way it is represented is masked in the cell. 

How to retrieve an Excel file crashed due to System Shut down

 If you are in a situation where your computer suddenly switched off and the Excel file you were working on got closed without saving.

Now for the below method to work your need to have "Auto Save" feature turned on in Microsoft Excel 

To check if Auto Save is turned on follow the below path in your Excel

File-->Options-->Save, now on the right hand side tick the "Save AutoRecover information every X minutes and also tick the "Keep the last autosaved version if I close without saving" option.

Now whenever you excel crashes, the most recent version which was autosaved despite you not saving it will be available when you open a blank excel workbook.

If you want see other versions of the crashed workbooks which are not saved. follow below path.

File-->Open-->Scroll till bottom and click on "Recover Unsaved Workbooks"