• Notyou@sopuli.xyz
    link
    fedilink
    arrow-up
    1
    ·
    2 months ago

    Great! I got a random Excel question. Sometimes when I pull reports at work the format for the price changes. Instead of showing the $ and the correct amount of spaces after the cent sign like .00, it has no $ and many digits after the cent sign like .000000000000000.

    Now when I try to change the cell format back to currency, accounting, text, or anything it keeps the same format and amount of digital after the cent sign. The work around I found is to open up a different Excel doc type it in the correct format and then copy and paste over the incorrect formatted cell.

    Do you can a better answer or did I explain horribly and your as confused as me when I try to fix Excel?