• 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?