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?
I haven’t encountered this but have you tried select the cell, going to the home ribbon tab I think, then clicking normal. Then adding the number formating you want
Yea when I said that I excel at Excel I was somewhat exaggerating, much as I have at every job interview I’ve ever had. It’s become something of a reflex these days. But as someone else has said I think that particular issue is just down to Excel being crap.
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?
I haven’t encountered this but have you tried select the cell, going to the home ribbon tab I think, then clicking normal. Then adding the number formating you want
Yea when I said that I excel at Excel I was somewhat exaggerating, much as I have at every job interview I’ve ever had. It’s become something of a reflex these days. But as someone else has said I think that particular issue is just down to Excel being crap.
That’s just excel being excel.
It Excels at formatting.