Log in
x
or
x
x
Register
x

or

Excel Tips: Edit > Convert

Change sign of values

How to change negative number to zero in Excel?

How to change negative numbers to positive in Excel?

How to change positive numbers to negative in Excel?

How to fix/convert trailing negative signs to real numbers in Excel?

How to move minus sign from right to left/back to front in Excel?

How to remove leading minus sign from numbers in Excel?

How to remove negative sign from numbers in Excel?

How to reverse signs of values in cells in Excel?

Convert between numbers and dates/time

How to convert hours, minutes and seconds to decimal hours in Excel?

How to convert seconds to time (hh mm ss ) or vice versa in Excel?

How to convert seconds to time (hh mm ss ) or vice versa in Excel?

How to convert time to decimal hours/minutes/seconds in Excel?

How to convert time to decimal over 24 hours in Excel?

How to convert time to integer hours or minutes in Excel?

How to convert week number to date or vice versa in Excel?

How to quickly convert milliseconds to a date in Excel?

Convert between numbers and text

Convert between number format and text format

How to change or convert number to text in Excel?

How to change or convert text to number in Excel?

How to convert 1-12 to month name in Excel?

How to convert letter grade to number in Excel?

How to convert letter to number or vice versa in Excel?

How to convert month name to number in Excel?

How to convert scientific notation to text or number in Excel?

How to convert weekday string to number in Excel?

How to mass convert numbers stored as text to numbers in Excel?

How to remove leading apostrophe from numbers in Excel?

How to remove text indicator (‘) in Excel?

Spell out numbers

How to convert currency to text with formatting or vice versa in Excel?

How to convert currency to words text in Excel?

How to quickly convert / change numbers to words in Excel?

How to quickly convert currency numbers to words in Excel?

How to quickly convert date to words in Excel?

How to spell out or convert numbers to English words in Excel?

How to spell out month of date in Excel?

Others

How to prevent or stop converting text string to number in Excel?

Convert to date

How to convert date stored as text to date in Excel?

How to convert dates to text or text formatting date to real date in Excel?

How to convert number string to date and time in Excel?

How to convert numbers to year/month/day or date in Excel?

How to convert yyyymmdd to normal date format in Excel?

How to convert yyyymmddhhmmss date format to normal datetime in Excel?

How to convert yyyy-mm-dd-to standard date in Excel?

How to mass convert text to date in Excel?

Currency Conversion

How to calculate currency conversion in Google Sheet?

How to convert currencies in Microsoft Excel?

How to quickly convert between dollars, pounds, euros in Excel?

Unit Conversion

How to convert angle between degrees and radians in Excel?

How to convert between hours, minutes, seconds or days in Excel?

How to convert between kb and mb, gb, tb and vice versa?

How to convert decimal degrees to degrees minutes seconds in Excel?

How to convert feet to inches, miles, and meters easily in Excel?

How to convert gallon to liter/ounce or vice versa in Excel?

How to convert inch to foot, cm or mm in Excel?

How to convert kilograms to stones and pounds in Excel?

How to convert temperature units between Celsius, Kelvin and Fahrenheit in Excel?

How to convert various unit measurements in cells in Excel?

How to easily convert between multiple energy units in Excel?

How to quickly convert cells between hectares and acres in Excel?

How to quickly convert pounds to ounces/grams/kg in Excel?

Number Systems

How to convert decimal number to binary/octal/hex number or vice versa in Excel?

How to convert hex number to decimal number in Excel?

How to convert hex to binary in Excel?

Others

How to convert all tables to ranges in active Worksheet?

How to convert between roman number and Arabic number in Excel?

How to convert cardinal number to ordinal number in Excel?

How to convert cells range to image in Excel?

How to convert formula to text string in Excel?

How to convert full state names to abbreviations in Excel?

How to convert html to text in cells in Excel?

How to convert PivotTable to list in Excel

How to convert range to table or vice versa in Excel?

How to convert text in text box to cell content in Excel?

How to convert text strings to formulas in Excel?

How to convert time string to time in Excel?

How to format number as ordinal (1st 2nd 3rd ) in Excel?

How to quickly convert an array table to a list table in Excel?

How to quickly convert time to text or number of hours/minutes/seconds in Excel?