Explain Number formatting types with example.
Answers
Answer:
Types of number format
Format Description
Fixed Point Number with a fixed number of digits after the decimal point
Integer A whole number with no decimals shown
Date Show number (days since 1 Jan 1900) as a date and/or time (see below for format options)
Boolean Display 0 as False , and any other number as True
#Suffix:-A letter after the number specifies power of ten. Ex. 12.35K
#Exponential:- Scientific notation, where the number after 'e' gives
the powers of ten .Ex. 1.2345e04
#General:- Floating point number with a specified number of significant digits. Reverts to scientific notation only when a number is extreme, or the non-scientific notation depiction would contain more than the specified number of significant digits. Ex. 12345.678
#Fixed Point:- Number with a fixed number of digits after the decimal point. Ex. 12345.68
#Integer:- A whole number with no decimals shown. Ex. 12346
#Date:-Show number (days since 1 Jan 1900) as a date and/or time . Ex. 12 Jan 2007
#Boolean:- Display 0 as False, and any other number as True True, False
#Hexadecimal:- Display an integer in base-16 using the digits 0-9 and a-f. The number is prefixed with 0x. When a negative number is displayed, its two's complement is shown. Ex. 0x303a
#Binary:- Display an integer in base-2 using the digits 0 and 1. The number is prefixed with 0xb. When the number is negative, its 64-bit two's complement is shown. Ex. 0b1100000011