this post was submitted on 18 Apr 2025
222 points (95.1% liked)
Asklemmy
47598 readers
575 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy π
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- [email protected]: a community for finding communities
~Icon~ ~by~ ~@Double_[email protected]~
founded 6 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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?
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.
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.