How many data format available in Excel – Excel Interview Question

How many data format available in Excel – Excel Interview Question From my previous blog How to change data format in Excel, I mentioned that Excel can present values into following 11 different data format available in excel: [vtftable ]Format;;;Usage;;;Example;;;Actual Value;nn;General;;;Not specific number format;;;1.5;;;1.5;nn;Number;;;general display of numbers;;;1.50;;;1.5;nn;Currency;;;general monetary values;;;$1.50;;;1.5;nn;Accounting;;;line up the currency symbols and decimal … Read more

How to change data format in Excel – Excel Interview Question

Format Cell

How to change data format in Excel?   [wpdevart_youtube]MjydYvzn_ts[/wpdevart_youtube] Excel can present values into following 11 different formats: [vtftable ]Format;;;Usage;;;Example;;;Actual Value;nn;General;;;Not specific number format;;;1.5;;;1.5;nn;Number;;;general display of numbers;;;1.50;;;1.5;nn;Currency;;;general monetary values;;;$1.50;;;1.5;nn;Accounting;;;line up the currency symbols and decimal points in a column;;; $1.50 ;;;1.5;nn;Date or Time;;;Date OR Time Format;;;1/01/1900 12:00:00 PM;;;1.5;nn;Precentage;;;multiply the cell value by 100 and display … Read more