How to Convert Dollars, Text, Percent, and Dates in Google Sheets

1 month ago 24

You tin format the information successful your cells a fewer antithetic ways for currency, dates, percentage, text, and numbers. If you’re moving with formulas wherever you privation to format those results, you tin usage a fistful of Google Sheets functions.

These functions enactment with different functions and formulas, but they besides enactment connected their own. So whichever mode you determine to usage them, we’ll amusement you the syntax and arguments you need.

Format arsenic Dollars: TO_DOLLARS

When you privation to person information to dollars, you tin usage the TO_DOLLARS function. The syntax is TO_DOLLARS(value) with conscionable that 1 required argument. You tin usage a compartment notation oregon inserted value.

The relation is equivalent to utilizing Format > Number > Dollars successful the menu.

Note: This relation does not convert different currencies to U.S. dollars. Instead, you tin usage the GOOGLEFINANCE relation for existent speech rates.

To person a worth successful a compartment to dollars, insert the compartment notation into the formula:

=TO_DOLLARS(A1)

To person an amount, simply insert the fig into the formula:

=TO_DOLLARS(57.29)

To adhd numbers successful a compartment scope and person the effect to dollars, usage this formula:

=TO_DOLLARS(SUM(A1:A5))

Format arsenic Text: TO_TEXT

Maybe you person a fig that you privation to person to text. Here, you tin usage the TO_TEXT function. The syntax is TO_TEXT(value) wherever you tin usage a compartment notation oregon fig for the argument.

The relation is equivalent to placing an apostrophe successful beforehand of the number.

To person a fig successful a cell, insert the compartment notation into the formula:

=TO_TEXT(A1)

To person a circumstantial number, insert it into the look instead:

=TO_TEXT(5.99)

Format arsenic Percentage: TO_PERCENT

When you calculate a percent successful Google Sheets, you whitethorn privation to format it arsenic such. This is erstwhile TO_PERCENT comes successful handy. The syntax is TO_PERCENT(value) wherever you tin usage a compartment notation oregon fig for the argument.

The relation is equivalent to Format > Number > Percent successful the menu.

To person a worth successful a cell, insert the compartment notation into the formula:

=TO_PERCENT(A1)

To person a definite value, see it successful the look instead:

=TO_PERCENT(0.123)

To cipher the percent and format it arsenic such, you tin usage the pursuing formula. This calculates the percent for portion successful compartment A1 of the full successful compartment B1 and formats the result.

=TO_PERCENT(A1/B1)

Format arsenic a Date: TO_DATE

Have you ever tried to participate a day into a compartment and ended up with a fig instead? For example, you whitethorn benignant successful 9/22/2022 and extremity up with 44826.

RELATED: How to Create a Custom Date oregon Time Format successful Google Sheets

The TO_DATE relation converts that fig to the day you need. The syntax is TO_DATE(value) wherever you tin usage a compartment notation oregon fig for the argument.

The relation is equivalent to Format > Number > Date successful the paper and formats the effect arsenic MM/DD/YYYY.

To person a worth successful a cell, insert the compartment notation into the formula:

=TO_DATE(A1)

To person a circumstantial value, simply insert it into the look instead:

=TO_DATE(44826)

Format arsenic a Number: TO_PURE_NUMBER

On the other broadside of formatting, you whitethorn privation to instrumentality your dollar, text, percentage, oregon day and turn it into a axenic number. For this, usage the TO_PURE_NUMBER function. The syntax is TO_PURE_NUMBER(value) wherever you tin usage a compartment notation oregon formatted worth for the argument.

RELATED: How to Change and Create Custom Number Format successful Google Sheets

The relation is akin to Format > Number > Normal lone without immoderate formatting specified arsenic a comma for thousands.

To person the day successful compartment A1 to a axenic number, you would usage this formula:

=TO_PURE_NUMBER(A1)

To person a percent to a number, insert it into the formula:

=TO_PURE_NUMBER(25%)

To adhd dollar amounts successful a compartment scope and format the effect arsenic a axenic number, you would usage this formula:

=TO_PURE_NUMBER(SUM(A1:A5))

The adjacent clip you request to person oregon format a circumstantial fig oregon substance oregon the results of a formula, support these Google Sheets functions successful mind.

RELATED: 9 Basic Google Sheets Functions You Should Know

Read Entire Article