CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online log in · register
Home › brightcyclist2 › Posts

Posts by brightcyclist2

56 posts shown.

How to protect your anonymity on Reddit? in Feedback & Suggestions ·
Nicholas King said:The fact that Rosie is a moderator has absolutely nothing to do with what happened.

That’s exactly the point the OP is making. That is the crucial fact here. We are talking about a moderator who is behaving inappropriately. It doesn't require deep analysis or much intellect to see that. Any attempt to throw mud at the original poster is essentially a mob mentality masquerading as approval. Because, apparently, she "earned" it with her short skirt, fishnets, and manicured nails? Should she be ashamed for even complaining about those overzealous cops pinning her against a cruiser?
Taylor Patel2 said:My apologies if this has already been covered—and looking at 100+ pages of history, I’m almost certain it has...

Basically, I want to format an Excel cell so that when I type "1701" and hit enter, it automatically converts to a date like 01/17/12 (or 01/17/2012, doesn't matter). I just want to breeze through data entry without the headache.

I thought I could just use "Format Cells" and pick a date style, but when I type something like 170112 with a dd/mm/yy format selected, I get some absolute nonsense date instead. Why does it do that?

I've been scouring the web, but I haven't found a straight answer yet. Figured I'd try my luck here before I lose my mind searching further.

I'm using Microsoft Office 2007.

Thanks in advance! :*

Just type 01/17 instead of 1701.
Princesses in Feedback & Suggestions ·
It’s truly fascinating how the moderators exercise their authority. They swoop in to edit a (controversial) ad using some rather mindless and inappropriate justification—simply because, apparently, she decided my post didn't fit her vision of the topic.

I'll quote: "Let me repeat:
You are free to write an ad that actually follows an advertising structure (semantic nature) and makes sense. Throw in princesses wherever you want—but it must function as an ad within the 'Classifieds' thread. Random metaphorical sentences are considered trolling or commenting, and they will be deleted."

How is a text about a princess actually in conflict with those rules? It seems the only reason it was edited and sanctioned was because it didn't align with the moderator's personal standard compared to everyone else's posts.

Dictating style and format to forum members is, to put it mildly, crossing a line.

This forum is definitely heading straight into a ditch (I’ll put "hell" in parentheses since it’s likely deemed too vulgar for polite conversation).

Drop the ego and the vanity. Let people write however they want in that thread. Just sanction the stuff that is actually disgusting, offensive, or clearly inappropriate.
Angela Long84 said:Hey everyone,
I'm running into some issues with Access 2007. My main goal is just to build a database,
but then I hit a wall with filtering, queries, and reports.
Is there anyone here who actually knows their stuff and would be willing to point me in the right direction? Just looking for the basic workflow to get things done.

There are endless tutorials online, so you might as well use them to suit your needs. Honestly, giving you specific advice without more context is pretty pointless.
Trolling and constant nitpicking in Feedback & Suggestions ·
hollowtrucker77 said:Is the name of something really the most important thing about it?
I mean, I don't know, it just doesn't feel that way to me, especially for people who actually give a damn about having a conversation that isn't cluttered with useless noise and distractions.

Too often, moderators get hung up on a username rather than the actual quality of the debate. They label a handle as "trolling" just to push people away from the conversation and the pdf.
Trolling and constant nitpicking in Feedback & Suggestions ·
Nicholas King said:On a neighboring thread, the question of what actually constitutes "trolling" has resurfaced—for some reason or another—so I am starting this topic (which, naturally, could be summarily deleted based on someone’s subjective whim) because it remains a perennial stumbling block on this American forum.

I suspect we are dealing with two distinct issues that are being stubbornly "kept alive" for no apparent reason, despite being entirely unnecessary. First, there is the issue from the user's perspective: no matter how perfect a definition you craft for a specific punishable category, you cannot prevent a bad moderator from being a bad moderator. It is impossible to turn an argument into an algorithm, and by extension, it is just as impossible to fully automate the sanctioning of rule-breaking within those arguments; there will always be that "gray area" where everything ultimately hinges on that infamous "discretionary moderator judgment."

On the other hand, there actually is a way to significantly shrink that gray area—and thereby reduce the amount of friction between users and administration: namely, it is completely unclear why, on this site, absolutely everything gets lumped under the label of "trolling" (resulting in vastly different users being uniformly branded as trolls), or why trolling is treated like some wild card a moderator can play whenever and however they feel like it.

I don't presume to think I can provide some flawless, universal definition of trolling when no one else has managed it—but, I do believe there is a solution that would simplify things; specifically, there are two obvious forms of trolling that are beyond dispute: the first is the total fabrication of stories about Milen... oops 😁, Soraya-topica, where people post entirely made-up narratives for reasons I cannot fathom, just to trigger a wave of outrage and pathetic responses. The second is "jumping into a thread just to stir the pot": you walk into a discussion on Veganism and start typing about how meat-eaters are idiots and so on. These types of examples are easy to spot, and penalizing them would never lead to any misunderstanding.

That leaves us with that problematic segment that is constantly shoved under the "trolling" umbrella, when it could much more simply be called "disrupting the discussion." This is the part that cannot be captured by a clear definition that would eliminate a moderator's discretionary right to decide what is what based on their own (in)competence. While I realize I am essentially inviting a massive amount of ridicule here—since it is always easier to mock someone on the first volley and lean on the "that's just how it's always been" inertia rather than pausing to actually think—I seriously believe that renaming the "offtopic/spam" penalty to "offtopic/spam/disruption," and separating those instances from unambiguous trolling, would clear up many of the ongoing misunderstandings. There is plenty of room for debate regarding the how and the why without needing further clarification 🙂.

"Offtopic" is a clearly defined concept.
"Spam" is a broad category, much like trolling; almost anything can be shoehorned into it.
But "disrupting discussion"? That’s a term you can actually prove.

So, if we separate these categories, what exactly qualifies as undeniable trolling?

Once again, it comes down to a moderator's subjective judgment, their interpretation of the pdf, and whether they personally like or dislike a specific user. The term "trolling" is a gift to moderators—especially the bad ones—who can't provide a reasoned explanation for a warning or a ban. Instead, they just hide behind "trolling," using an ill-defined and opaque label to justify their actions.

It’s honestly ridiculous to see the exact same tone and level of communication result in vastly different penalties depending on whether the forum is strictly moderated or completely laid back.
Brenda Lee2 said:Could you walk me through the whole process in more detail? Something feels off here.

I hope you actually assigned those macros to the buttons.
nimbleangler21 said:Does anyone know how to calculate probability in Excel? Specifically, I need the probability that returns will be positive (
I tried using the NORM.INV function, but it just isn't working...

Try using the Z-test function as an example.
driftingpilot8 said:I tried transcribing that formula you gave me, but those symbols kept throwing everything off. It just wouldn't work.

Here is the complete formula. It’s incredibly simple—almost obvious.

The logic is simple: if A1 matches B1, you get a 1. If they don't? You get a 2. It’s basic conditional logic in Excel. Why overcomplicate things?

Thanks! 🙂

Regardless of the outcome, I just don't get how you... The logic is simple: if A1 matches B1, you get a 1. If they don't match, you get a 2. Why overcomplicate things? It’s basic conditional logic. Does it work? Yes. Is it efficient? Absolutely. The formula isn't working. So why does the one you claim is complete and correct actually function? 🤷
Taylor Campbell4 said:In Google Sheets, how do I set it up so that if a cell contains "word1" (meaning the cell might have other text too, but we just need "word1" to be part of it), then the next cell displays "word2"?

If A1 holds "word1" and you want that result in B1, then B1 should be:
=IF(ISNUMBER(SEARCH("word1",A1)),"word2","")
casualheron12 said:Hello.

I'm running into an issue with Excel. Ever since I had my computer reformatted, the Cut-Pasta function hasn't been working at all. Any ideas?
Can I use only copy-paste? Right now, the cells aren't retaining their original formatting—it's just dumping the raw text. Why does that happen?

Does anyone know how to fix this?

Thanks. 🙂

How do I run an Office repair?
Anyone still running Windows 7? in Software ·
Sean Edwards47 said:So,

I picked up a new laptop in Austria. It came with Windows 7 Home premium pre-installed, but then someone ran a clean install using a German version—which is incredibly irritating and impossible to follow.
Is there any simple, say, legal way to switch the language to English or American? I tried using a tool called Vistalizator, but it won't let me install it.

Thanks in advance for the help, and my apologies if this has already been covered.

Check Windows Update to see if you can download an American language pack. If you were running Ultimate, you could.
I'm terrified of failing my pets and plants! in Psychology & Therapy ·
I used to have this little blue parakeet living in a cage. She was incredibly lively and loud 😍, basically the mascot of our household. There wasn't a single conversation happening in our house where someone didn't try to chime in with her. Of course, she’d respond with those signature shrieks, though she only deigned to answer whoever she felt like. She was spirited, stubborn, and a total troublemaker. After a while, I decided the cage was getting too small. I figured I'd upgrade her to something much larger and more comfortable, complete with extras like a little swing. I moved her into the new setup, but she was visibly agitated; clearly, she wasn't a fan of the change. But hey, I thought I knew better than a bird, right? She went wild in the new cage, screeching and leaving feathers everywhere. I ignored the tantrum. Then, about an hour later, she just slumped to the bottom of the cage and stopped moving. It didn't take long to realize she was gone. Someone suggested she probably had a heart attack from the sudden shock of the new environment. Needless to say, I buried her in my backyard, through plenty of tears. And honestly? Not once did I stop to wonder if I was crazy for burying a bird. I know I'm not. It was the least she deserved. I've buried a few cats and dogs before, too. After that last burial, I made a solemn vow that there would be no more pets in this house. Until the next one. 🙂
restlessheron19 said:So, I have two questions...
1. The formula itself.
2. How do I stop this from happening? When I hit Shift+7 or even just "/", the keyboard triggers the "File" menu instead of typing the character.
Basically...I can't even type a simple slash in Excel using the standard method.

The formulas look solid. As for the slash issue—just double-click cell F1 to enter edit mode. That should let you type whatever you need.
lonebear14 said:Noooo, that’s not what I meant. Seriously? Here's an example: In my Excel sheet, I input customer data in cell A6, but then I need to jump straight to G16 to enter the invoice number. Right now, if I hit Enter or Tab from A6, I’m stuck tabbing through A7, A8, A9... all the way to A16, then shifting through B16, C16... until I finally hit G16. Is there a way to just leap from A6 to G16 with one keystroke? Just one? Download a standard IRS tax form and you'll see what I'm talking about.

The easiest fix? Lock the cells you want to skip, protect the worksheet, and set it so only unlocked cells can be selected.
Mocking lesbian marriage in Feedback & Suggestions ·
bluerider41... you’re being cold and unresponsive, which unfortunately means you can't react (or maybe you can, it doesn't matter). But look, the essence of MK and its players is well known to you. It is honestly baffling to me that you took such a serious, worthy topic like homosexuality and posted it right here on this PDF politics board. Whether it was intentional or not, I won't dwell on it, but what exactly did you expect from posting this? An academic debate? Or perhaps you thought we’d all just smile and applaud your attempt to get us to validate your personal inclinations and life beliefs?

The reality is you just don't get it. There is absolutely no hidden or overt intention here to mock or trivialize homosexuality in any real sense. What’s being mocked is your specific approach, your tone, and how you presented a topic that was originally sparked on MK. A topic with that much connotation—presented and forced the way you did it—simply doesn't belong on MK.

In several posts, it has been made crystal clear to you (and your supporters) that you have two choices: either embrace the banter or walk away. Instead of picking one of those two viable options, you chose a third, unacceptable path. You started attacking people and throwing tantrums, which, predictably, backfired.

You're young; I understand your drive to share your perspective and worldview. The only issue—one you stubbornly refuse to acknowledge—is that you expressed your views in the wrong place, using a tone and format that didn't fit. Your style of communication offends the very spirit and foundation of MK, and by extension, offends the regular members, men and women alike, who come here to find their corner of sarcasm and laughter. Because of that, you couldn't even bring yourself to read posts that were different from your own.

I hope you catch my drift. I’m inviting you to join us if you have a sense of humor, especially when it comes to yourself. If not, don't hold it against us for joking about an issue you consider vital. Just bypass this corner for your own sake, not ours.
restlessdrifter12 said:I tried everything and still nothing. The result keeps coming up as 0. I can't believe it's actually this complicated.

Something is off with the cell formatting.
Try opening a fresh worksheet and entering the data manually. Use that E89 formula if you get an autosum result of 0:00.
If it still shows 0:00, just open a completely new workbook.
restlessdrifter12 said:Fine, but how am I supposed to turn something like 01:12 into 1:12?
I have a tiny little million cells here if I want to do that manually.

Just select that "tiny little million" of cells and format them as h:mm.
Carol Reed65 said:Hey everyone! I'm working on my resume in Excel. Every time I start a line with a dash and hit enter, it turns the whole thing into a numbered list... how do I stop that?

In Excel? 😕 You’re clearly using Word. Just turn off the auto-numbering.
crimsonseal45 said:I have a question about Excel. Is it actually possible to set a limit where I type just five characters—numbers or letters—and then it automatically jumps to the next cell once I hit that fifth one?

Check this out