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?
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.
I had someone at work ask me if I was an expert at Excel. I’ve written macros in VBA and made formulas that would have been easier as a macro so I could save them as xlsx instead of xlsm. I said yes, with some hesitation. She asked me if I could help her with a problem and I said sure. The problem was a bunch of hidden cells. At least it wasn’t a bunch of data she’d deleted and wanted me to get back for her.
The amazing part was how hard it was to show the cells in the latest version of 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
Excel, it wouldn’t be useful but I’d still be great at it.
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?
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.
I had someone at work ask me if I was an expert at Excel. I’ve written macros in VBA and made formulas that would have been easier as a macro so I could save them as xlsx instead of xlsm. I said yes, with some hesitation. She asked me if I could help her with a problem and I said sure. The problem was a bunch of hidden cells. At least it wasn’t a bunch of data she’d deleted and wanted me to get back for her.
The amazing part was how hard it was to show the cells in the latest version of Excel.
The more I learn about Excel, the more I know I don’t know 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
That’s just excel being excel.
It Excels at formatting.