hubayi
V2EX  ›  问与答

这是 wps 的 bug 吗?

  •  
  •   hubayi · Apr 17, 2024 · 1626 views
    This topic created in 947 days ago, the information mentioned may be changed or developed.
    在 wpsd 的表格中 l 中,单元格 A1 是 008091D321E2 ,公式 =MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)&":"&MID(A1,9,2)&":"&MID(A1,11,2)"
    ,为什么得到的是 0:08:09:1D:32:1E?
    hubayi
    hubayi
    OP
    Apr 17, 2024
    1
    chagpt 说用 =TEXT(MID(A1,1,2),"00") & ":" & TEXT(MID(A1,3,2),"00") & ":" & TEXT(MID(A1,5,2),"00") & ":" & TEXT(MID(A1,7,2),"00") & ":" & TEXT(MID(A1,9,2),"00") & ":" & TEXT(MID(A1,11,2),"00"),可结果是 00:08:09:1D:32:1E ,还是不对。
    hubayi
    hubayi
    OP
    Apr 17, 2024
    2
    问题找到了,008091D321E2 前后有空字符串
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2387 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 29ms · UTC 03:20 · PVG 11:20 · LAX 19:20 · JFK 22:20
    ♥ Do have faith in what you're doing.