在Excel中轉換公式
Did you know that Excel can convert numbers from one measurement system to another measurement system? Yes you can with the CONVERT Formula! You will be surprised at what units it can convert for you!
Key Takeaways
-
Convert Units Easily – The
CONVERTfunction allows you to switch between different measurement units, such as length, weight, temperature, and more. - Wide Range of Unit Types – Supports conversions for distance (meters to miles), weight (grams to pounds), time (seconds to minutes), and many other categories.
-
Syntax Simplicity – The formula structure is
=CONVERT(number, from_unit, to_unit), making it easy to use. - Unit Abbreviations Are Key – Each unit has a specific abbreviation (e.g., “m” for meters, “km” for kilometers), and incorrect abbreviations will result in an error.
- Enhances Data Accuracy – Instead of manually converting measurements, the formula ensures precise unit conversion, reducing human error.
Table of Contents
Formula Overview
What does it do?
Converts a number from one measurement system to another
Formula breakdown:
=CONVERT(number, from_unit, to_unit)
What it means:
=CONVERT(number, starting measurement system, target measurement system)
How to Use CONVERT Formula in Excel
STEP 1: We need to enter the CONVERT function in a blank cell:
=CONVERT(
STEP 2: The CONVERT arguments:
number
What is the numeric measurement?
Select the cell containing the number that you want to convert
=CONVERT(C9,
from_unit
What is the starting measurement system?
Select the cell containing the starting measurement system.
=CONVERT(C9, D9,
to_unit
What is the target measurement system?
Select the cell containing the target measurement system.
=CONVERT(C9, D9, E9)
Apply the same formula to the rest of the cells by dragging the lower right corner downwards.
You now have your conversions completed!
List of All Units
Here is an extensive list of all of the units that you can use:
| Category | Unit | Usage in CONVERT FORMULA |
| Weight and mass | Gram | “g” |
| Weight and mass | Slug | “sg” |
| Weight and mass | Pound mass (avoirdupois) | “lbm” |
| Weight and mass | U (atomic mass unit) | “u” |
| Weight and mass | Ounce mass (avoirdupois) | “ozm” |
| Weight and mass | Grain | “grain” |
| Weight and mass | U.S. (short) hundredweight | “cwt” or “shweight” |
| Weight and mass | Imperial hundredweight | “uk_cwt” or “lcwt” (“hweight”) |
| Weight and mass | Stone | “stone” |
| Weight and mass | Ton | “ton” |
| Weight and mass | Imperial ton | “uk_ton” or “LTON” (“brton”) |
| Distance | Meter | “m” |
| Distance | Statute mile | “mi” |
| Distance | Nautical mile | “Nmi” |
| Distance | Inch | “in” |
| Distance | Foot | “ft” |
| Distance | Yard | “yd” |
| Distance | Angstrom | “ang” |
| Distance | Ell | “ell” |
| Distance | Light-year | “ly” |
| Distance | Parsec | “parsec” or “pc” |
| Distance | Pica (1/72 inch) | “Picapt” or “Pica” |
| Distance | Pica (1/6 inch) | “pica” |
| Distance | U.S survey mile (statute mile) | “survey_mi” |
| Time | Year | “yr” |
| Time | Day | “day” or “d” |
| Time | Hour | “hr” |
| Time | Minute | “mn” or “min” |
| Time | Second | “sec” or “s” |
| Pressure | Pascal | “Pa” (or “p”) |
| Pressure | Atmosphere | “atm” (or “at”) |
| Pressure | mm of Mercury | “mmHg” |
| Pressure | PSI | “psi” |
| Pressure | Torr | “Torr” |
| Force | Newton | “N” |
| Force | Dyne | “dyn” (or “dy”) |
| Force | Pound force | “lbf” |
| Force | Pond | “pond” |
| Energy | Joule | “J” |
| Energy | Erg | “e” |
| Energy | Thermodynamic calorie | “c” |
| Energy | IT calorie | “cal” |
| Energy | Electron volt | “eV” (or “ev”) |
| Energy | Horsepower-hour | “HPh” (or “hh”) |
| Energy | Watt-hour | “Wh” (or “wh”) |
| Energy | Foot-pound | “flb” |
| Energy | BTU | “BTU” (or “btu”) |
| Power | Horsepower | “HP” (or “h”) |
| Power | Pferdestärke | “PS” |
| Power | Watt | “W” (or “w”) |
| Magnetism | Tesla | “T” |
| Magnetism | Gauss | “ga” |
| Temperature | Degree Celsius | “C” (or “cel”) |
| Temperature | Degree Fahrenheit | “F” (or “fah”) |
| Temperature | Kelvin | “K” (or “kel”) |
| Temperature | Degrees Rankine | “Rank” |
| Temperature | Degrees Réaumur | “Reau” |
| Volume | Teaspoon | “tsp” |
| Volume | Modern teaspoon | “tspm” |
| Volume | Tablespoon | “tbs” |
| Volume | Fluid ounce | “oz” |
| Volume | Cup | “cup” |
| Volume | U.S. pint | “pt” (or “us_pt”) |
| Volume | U.K. pint | “uk_pt” |
| Volume | Quart | “qt” |
| Volume | Imperial quart (U.K.) | “uk_qt” |
| Volume | Gallon | “gal” |
| Volume | Imperial gallon (U.K.) | “uk_gal” |
| Volume | Liter | “l” or “L” (“lt”) |
| Volume | Cubic angstrom | “ang3” or “ang^3” |
| Volume | U.S. oil barrel | “barrel” |
| Volume | U.S. bushel | “bushel” |
| Volume | Cubic feet | “ft3” or “ft^3” |
| Volume | Cubic inch | “in3” or “in^3” |
| Volume | Cubic light-year | “ly3” or “ly^3” |
| Volume | Cubic meter | “m3” or “m^3” |
| Volume | Cubic Mile | “mi3” or “mi^3” |
| Volume | Cubic yard | “yd3” or “yd^3” |
| Volume | Cubic nautical mile | “Nmi3” or “Nmi^3” |
| Volume | Cubic Pica | “Picapt3”, “Picapt^3”, “Pica3” or “Pica^3” |
| Volume | Gross Registered Ton | “GRT” (“regton”) |
| Volume | Measurement ton (freight ton) | “MTON” |
| Area | International acre | “uk_acre” |
| Area | U.S. survey/statute acre | “us_acre” |
| Area | Square angstrom | “ang2″ or “ang^2” |
| Area | Are | “ar” |
| Area | Square feet | “ft2” or “ft^2” |
| Area | Hectare | “ha” |
| Area | Square inches | “in2” or “in^2” |
| Area | Square light-year | “ly2” or “ly^2” |
| Area | Square meters | “m2” or “m^2” |
| Area | Morgen | “Morgen” |
| Area | Square miles | “mi2” or “mi^2” |
| Area | Square nautical miles | “Nmi2” or “Nmi^2” |
| Area | Square Pica | “Picapt2”, “Pica2”, “Pica^2” or “Picapt^2” |
| Area | Square yards | “yd2” or “yd^2” |
| Information | Bit | “bit” |
| Information | Byte | “byte” |
| Speed | Admiralty knot | “admkn” |
| Speed | Knot | “kn” |
| Speed | Meters per hour | “m/h” or “m/hr” |
| Speed | Meters per second | “m/s” or “m/sec” |
| Speed | Miles per hour | “mph” |
The following abbreviated unit prefixes can be added in front of any metric from_unit or to_unit.
| Prefix | Multiplier | Abbreviation |
| yotta | 1.00E+24 | “Y” |
| zetta | 1.00E+21 | “Z” |
| exa | 1.00E+18 | “E” |
| peta | 1.00E+15 | “P” |
| tera | 1.00E+12 | “T” |
| giga | 1.00E+09 | “G” |
| mega | 1.00E+06 | “M” |
| kilo | 1.00E+03 | “k” |
| hecto | 1.00E+02 | “h” |
| dekao | 1.00E+01 | “da” or “e” |
| deci | 1.00E-01 | “d” |
| centi | 1.00E-02 | “c” |
| milli | 1.00E-03 | “m” |
| micro | 1.00E-06 | “u” |
| nano | 1.00E-09 | “n” |
| pico | 1.00E-12 | “p” |
| femto | 1.00E-15 | “f” |
| atto | 1.00E-18 | “a” |
| zepto | 1.00E-21 | “z” |
| yocto | 1.00E-24 | “y” |
Frequently Asked Questions
What is the purpose of the CONVERT function in Excel?
The CONVERT function is used to change a value from one unit of measurement to another, such as feet to meters or Celsius to Fahrenheit.
Why is my CONVERT formula not working?
Check if you are using the correct unit abbreviations. If the unit is unsupported or misspelled, Excel will return an error.
Can the CONVERT function handle currency conversions?
No, the CONVERT function does not support currency conversion. You will need real-time exchange rate data for that.
How do I convert temperature from Celsius to Fahrenheit in Excel?
Use the formula =CONVERT(temperature, "C", "F"), replacing “temperature” with your actual value.
Can I use the CONVERT function with custom units?
No, the function only works with predefined unit types available in Excel. Custom conversions require separate calculations or VBA scripting.
以上是在Excel中轉換公式的詳細內容。更多資訊請關注PHP中文網其他相關文章！
熱AI工具
Undress AI Tool
免費脫衣圖片
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Stock Market GPT
人工智慧支援投資研究，做出更明智的決策
熱門文章
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
![修復滾動條缺少Excel中的錯誤[故障排除指南]](https://img.php.cn/upload/article/001/242/473/175816188366414.png?x-oss-process=image/resize,m_fill,h_207,w_330)
修復滾動條缺少Excel中的錯誤[故障排除指南]
Sep 18, 2025 am 10:18 AM
滾動條在有效地通過大量數據進行導航方面起著至關重要的作用，其突然消失會破壞您的工作流程。在本故障排除指南中，我們將向您展示如何將滾動條帶回去Excel並重新獲得S
為什麼我的ppt文件這麼大？診斷和修復大PPT文件大小的指南。
Sep 17, 2025 am 02:11 AM
ifyourpowerpointfileisslowtoopenorsend，redictitSsizeby：1.compressinghigh-resolutionImages.2.Replacingembedembeddedaudio/videOwithIthLinkedFiles.3.deletingHidendingHidendorduplicalideslides.4.4.cleaninguptheslidemaster.5.savingInoptimptimizedppptxxxxxfumpppttxformate。
如何在Word中使用複選框創建可填充的表格
Sep 16, 2025 am 04:29 AM
EnabletheDevelopertabviaFile>Options>CustomizeRibbonbycheckingDeveloper.2.InsertaCheckboxContentControlfromtheControlsgroupontheDevelopertabwhereneeded.3.Addmultiplecheckboxesbyrepeatingtheinsertionprocessandaligningthemneatlywithtextortables.4
如何將文檔保存到Microsoft Word中的OneDrive
Sep 21, 2025 am 11:36 AM
如果您在Word中工作，並希望將文檔直接保存到OneDrive，則該過程很簡單。只需按照以下簡單的步驟操作：單擊“ file'Choose” as as as'pick“ OneDrive”作為保存位置選擇適當的文件夾 - 使用
如何打開Windows中未知文件擴展
Sep 19, 2025 am 09:33 AM
您是否曾經偶然發現了一個奇怪或陌生的擴展名的文件？如果是，您可能會熟悉不知道哪個程序可以打開它的煩惱。好消息是，有一些有效的方法來確定正確的軟件和
如何將PPT保存為PDF？
Sep 21, 2025 am 01:18 AM
打開要轉換的PPT文件；2.點擊“文件”進入後台；3.選擇“另存為”並指定保存位置；4.在“保存類型”中選擇“PDF”，可選質量與選項；5.點擊“保存”完成轉換，PDF將保留原有佈局且適用於分享或打印。
如何更新Windows中的Microsoft鼠標驅動程序
Sep 20, 2025 am 09:09 AM
保持駕駛員的最新狀態至關重要，尤其是對於像鼠標這樣的外圍設備。擁有Microsoft Mouse的最新驅動程序可以幫助您兼容和穩定性，從而使您能夠充分利用硬件
如何將Word文檔插入PPT？
Sep 21, 2025 am 01:39 AM
ToinsertaWorddocumentintoPowerPoint,embeditasanobjectbygoingtoInsert→Object→Createfromfile,thenbrowseandselectthefile,optionallycheckingDisplayasiconorLinktofiletomaintainupdates;2.Forquickcontenttransfer,copytextfromWordandpasteintoPowerPointusingKe
