this post was submitted on 18 Apr 2025
223 points (95.1% liked)
Asklemmy
49216 readers
1030 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
- !lemmy411@lemmy.ca: a community for finding communities
~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~
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?
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.
The more I learn about Excel, the more I know I don't know Excel.