1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • convert meters to feet/inches

    From [email protected]@21:1/5 to All on Mon Dec 9 13:06:52 2019
    hello,I tried the formula and it works great, but what if I need to show the fraction also, like (18feet8inches1/8fraction)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Mon Dec 9 22:46:18 2019
    Hi,

    Am Mon, 9 Dec 2019 13:06:52 -0800 (PST) schrieb [email protected]:

    hello,I tried the formula and it works great, but what if I need to show the fraction also, like (18feet8inches1/8fraction)

    try:

    =INT(CONVERT(A1,"m","ft"))&" feet "&TEXT(MOD(CONVERT(A1,"m","ft"),1)*12,"# ?/?")&" inches"


    Regards
    Claus B.
    --
    Windows10
    Office 2016

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to All on Mon Dec 9 15:33:58 2019
    wow works great!!! thank you so much, really appreciate it

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Justin Kuo@21:1/5 to [email protected] on Tue Sep 19 16:30:15 2023
    On Monday, December 9, 2019 at 6:34:01 PM UTC-5, [email protected] wrote:
    wow works great!!! thank you so much, really appreciate it
    I need to modify the formula to handle negative measurements.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bandarjitu Sites@21:1/5 to All on Mon Oct 16 05:45:06 2023
    BANDARJITU - DAFTAR LINK ALTERNATIF RESMI BANDARJITU

    🌐LINK ALTERNATIF🌐
    ✅ https://winbandarjitu.com
    ✅ https://bandarjitugacor.com
    ✅ https://bandarjituofficial.com
    ✅ https://bandarjitumaxwin.com

    🌐LINK ANTI BLOKIR🌐
    ✅ https://bandarjitu.asia

    🌐LINK PORTAL INFORMASI🌐
    ✅ https://bandarjitu.news

    Gabung sekarang bersama Bandarjitu dan dapatkan Special Promotion hanya dari Situs Terbaik 2023 - 2024 Bandarjitu !!!
    JOIN NOW : https://bandarjituku.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)