Convert a number with two decimals in Excel and Google Sheets
=TEXT(A2,"0.00")
A2 = data cell
Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.Convert number with two decimal in Excel
How to convert a number with two decimal in Excel?Convert number with two decimal in Excel
CONVERT NUMBER WITH TWO DECIMAL — EXCEL FORMULA AND EXAMPLE
CONVERT NUMBER WITH TWO DECIMAL — EXCEL FORMULA AND EXAMPLE
=TEXT(A2,"0.00")
A2 = data cell
"0.00" = format, add or remove the second part .00 to increase/decrease decimal numbers
C3 = result will be stored as a text
💡 Detailed TEXT format explained here
Convert number with two decimal in Google Sheets
How to convert a number with two decimal in Google Sheets?Convert number with two decimal in Google Sheets
CONVERT NUMBER WITH TWO DECIMAL — GOOGLE SHEETS FORMULA AND EXAMPLE
CONVERT NUMBER WITH TWO DECIMAL — GOOGLE SHEETS FORMULA AND EXAMPLE
=TEXT(A2,"0.00")
A2 = data cell
"0.00" = format, add or remove the second part .00 to increase/decrease decimal numbers
C3 = result will be stored as a text
💡 Detailed TEXT format explained here
Other useful convert formulas in Excel and Google Sheets
- CONVERT formulas and example
- Convert alphabet letter to number
- Convert decimal numbers to binary
- Convert letter to number
- Convert number to alphabet letter
- Convert number to roman number
- Convert roman number to number
- Convert number stored as a text to date
- Convert weekday string to number
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria