【EXCEL】EXCEL - 數值轉換為羅馬數字？

<div class="jane_bar" style="margin: auto auto 35px; padding: 20px; border-width: 5px 0px 0px; border-style: solid dotted dotted; border-color: RGB(33,115,70) gray gray; border-image: initial; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 16px; line-height: 50px; font-family: "Microsoft JhengHei", cwTeXHei, "Open Sans"; vertical-align: baseline; color: rgb(40, 40, 40); letter-spacing: 1px; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; border-radius: 0px; width: 100%; background-color: rgb(207, 241, 222); box-sizing: border-box; text-align: center;"> 【EXCEL】EXCEL - 數值轉換為羅馬數字？

在EXCEL中，數值如何轉換為羅馬數字？

此時可以使用 ROMAN()函數

公式：=ROMAN(A2)

<h2 class="ih-heading" style="margin: 0px 0px 15px; padding: 0px; border-width: 0px 0px 2px 2px; border-top-style: initial; border-right-style: initial; border-bottom-style: solid; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: RGB(33,115,70); border-left-color: rgb(2, 141, 99); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: normal; font-stretch: inherit; font-size: 18px; line-height: 1; font-family: inherit; vertical-align: baseline; color: rgb(40, 40, 40); orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; letter-spacing: 0.7px; background-color: rgb(255, 255, 255);"> 延伸閱讀

<p style="margin: 1em 0px; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 1.1rem; line-height: 1.75rem; font-family: "Noto Sans TC", 微軟正黑體, sans-serif; vertical-align: baseline; color: rgb(52, 52, 52); letter-spacing: 1px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; background-color: rgb(255, 255, 255);"> ■ EXCEL 相關文章🔍

#【EXCEL】EXCEL - 數值轉換為羅馬數字

(adsbygoogle = window.adsbygoogle || []).push({});

隨手記錄

【EXCEL】EXCEL - 數值轉換為羅馬數字？

延伸閱讀

廣告一