Excel Formulas - Convert Category
Stop struggling with complex spreadsheets. Learn how to quickly convert Excel formulas into values, text, or different cell references with our easy-to-follow guide. Master your data today!
Excel Formulas to Convert and Extract Numbers From Text
Learn the best Excel formulas to extract numbers from text strings or easily convert text-formatted numbers into actual numeric values.
Excel Formulas to Convert Decimals to Percentages and Vice Versa
Learn how to easily convert decimals to percentages in Excel using formulas and formatting to keep your exact decimal places intact.
How to Convert Military Time to Standard Time in Excel
Learn how to easily convert military time (24-hour format) to standard AM/PM time in Excel using simple formulas and cell formatting.
How to Convert Decimals to Fractions in Excel Using Formulas
Learn how to quickly convert decimals to fractions in Excel using the TEXT formula and simple cell formatting with this easy step-by-step guide.
Excel Formulas to Convert UTC to Local Time
Learn how to easily convert UTC to local time in Excel using a simple formula to adjust for time zone offsets.
Excel Formulas to Convert Standard Dates to Unix Timestamps
Easily convert standard dates to Unix timestamps (and vice versa) in Excel with these simple formulas and step-by-step examples.
Excel Formulas to Convert IP Addresses to Binary Code
Convert IP addresses to binary code in Excel instantly. Learn the exact formulas to translate IPv4 octets into 32-bit binary format step-by-step.
Excel Formulas to Convert Full Name to Last Name First
Easily convert full names to "Last Name, First Name" format in Excel using simple formulas. Clean up your spreadsheets and contact lists instantly!
Excel Formulas to Convert Dates to Days of the Week
Learn how to use the Excel TEXT formula to easily convert any date into the day of the week (e.g., Monday or Mon) with this quick, step-by-step guide.
Excel Formulas to Extract Domain Names From Email Addresses
Learn how to easily extract domain names from email addresses in Excel using simple formulas like TEXTAFTER, MID, and FIND.
Excel Formula to Convert Latitude and Longitude to Decimal Degrees
Easily convert latitude and longitude from Degrees Minutes Seconds (DMS) to Decimal Degrees with this quick and simple Excel formula guide.
Converting HTML Entities to Plain Text Using Excel Formulas
Easily convert HTML entities to plain text in Excel. Learn the best formulas and methods to decode characters like `&` and `"` instantly.
Excel Formulas for Converting Numbers to Spelled-Out Words
Easily convert numbers to words in Excel using formulas and the SpellNumber VBA code-perfect for automating invoices, check amounts, and financial reports.
How to Convert Julian Dates to Standard Dates in Excel
Learn how to easily convert Julian dates to standard calendar dates in Excel with these simple, step-by-step formulas.
How to Build a Dynamic Currency Converter in Excel Using Real-Time Exchange Rates
Learn how to easily convert currency in Excel using dynamic, real-time exchange rates with this simple step-by-step formula guide.
Excel Formulas to Convert Feet and Inches to Decimal Feet
Learn how to easily convert feet and inches to decimal feet in Excel with these simple, step-by-step formulas.
Excel Formulas to Convert Megabytes to Gigabytes (MB to GB)
Learn how to easily convert Megabytes (MB) to Gigabytes (GB) in Excel using a simple division formula or the built-in CONVERT function.
Excel Formulas to Convert 12-Hour Time to 24-Hour Format
Learn how to quickly convert 12-hour time (AM/PM) to 24-hour format in Excel using simple formulas and easy cell formatting tricks.
How to Convert Numbers to Text in Excel Using Formulas
Learn how to quickly convert numbers to text in Excel using the TEXT function and other simple formulas to preserve leading zeros and formatting.
Excel Formulas to Convert Text to Valid Dates
Learn how to quickly convert text into valid Excel dates using simple formulas like DATEVALUE, Text to Columns, and formatting tricks.
How to Convert Uppercase to Title Case in Excel Using the PROPER Function
Easily convert uppercase text to title case in Excel using the PROPER function. Learn the quick formula to clean up your spreadsheet capitalization instantly.
How to Convert Unix Timestamp to GMT Date in Excel
Easily convert Unix timestamps to GMT/UTC dates in Excel with this simple, step-by-step formula to translate epoch time instantly.
How to Convert Military Time to Standard Time in Excel
Learn how to easily convert military time (24-hour) to standard time (12-hour AM/PM) in Excel using simple formulas and custom cell formatting.
How to Convert Roman Numerals to Arabic Numbers in Excel
Learn how to easily convert Roman numerals to Arabic numbers in Excel using the ARABIC function with this quick, step-by-step guide.
Converting Arabic Numbers to Roman Numerals With the Excel ROMAN Function
Learn how to use the Excel ROMAN formula to instantly convert Arabic numbers to Roman numerals with this quick, step-by-step guide.
Converting Decimal to Binary in Excel: The DEC2BIN Formula
Learn how to easily convert decimal numbers to binary in Excel using the built-in DEC2BIN formula with quick, step-by-step examples.
How to Convert Binary to Decimal in Excel Using the BIN2DEC Function
Learn how to quickly convert binary numbers to decimal in Excel using the simple BIN2DEC formula, complete with easy-to-follow examples.
Converting Radians to Degrees in Excel: The DEGREES Formula
Learn how to easily convert radians to degrees in Excel using the built-in DEGREES function or a simple math formula in this quick, step-by-step guide.
Excel Formula to Convert Week Number to Start Date
Learn the simple Excel formula to quickly convert any week number and year into its starting date with this easy step-by-step guide.
Excel Formulas to Convert Julian Date to Calendar Date
Easily convert Julian dates (YYDDD or YYYYDDD) to standard calendar dates in Excel with these quick and simple formulas.