Learn to show Indian Currency Format in Excel (On request of Mr. Ksan Warjri) Indian numbers are grouped differently than standard English numbers. Learn to format numbers and amounts in Indian currency and number formats. English Grouping : 123,456,789.01 Indian Grouping : 12,34,56,789.01 =============================== Quick and easy fix to show numbers in Indian format ================================= […]
How to Highlight Cells with Duplicate Values in a Range? By using Conditional Formatting in Excel we can Highlight Duplicate Cells. Steps to do: ======== Select the Cells/Range you wish to compare Select the Home Tab Select Conditional Formatting Select Highlight Cell Rules Select Duplicate Values Select a Highlight Color Select Okay Tada..!! Magic… All the […]
Qsn: How to calculate the Age between two Dates / Times and show it in a meaningful way?
Sol: Use the simple formula “A-B” (NewDate – OldDate) just same as we subtract two numerical values, but added with a simple trick… Know how…
Round Numbers To The Nearest 1000 Often in Excel, when working with large numbers it is common practice to show numbers as thousands, with a note to that effect shown somewhere on the report. To display your numbers to the nearest thousand in Excel you do not need to change any numbers or do any […]
