Posts by frozenheron7

redridge35 said:Just use the comma, thanks.

Don't mention it. But look, let me give you a bit of advice before you run into more headaches—when you're typing out large numbers in Excel, please, for the love of God, don't manually type in spaces like 1 000 000. Just type it straight: 1000000. If you start adding manual spaces, you're just begging for errors down the road. You can always change how the number looks later on using format cells -> custom. It’s much cleaner that way.

redridge35 said:My Excel 2010 keeps turning numbers into dates. I know there's a quick fix if I put an apostrophe before the number or change the format cells to text, but then all my formulas break. Is there actually a permanent solution for this?

Just try using Format Cells -> Number

EDIT: Are you perhaps using a period instead of a decimal point?

Timothy Patel66 said:I'm trying to figure out how to change the ribbon language—basically, I want all my Microsoft Office programs to be in English. This American version I'm stuck with is incredibly difficult and unintelligible... I am sick and tired of wasting precious time hunting for a setting that would take me 0.02 seconds to find if it were just in English...

In Word (File/Options/Language), the only thing I can do is go to the 'Editing Languages' section and switch from American to English, but then absolutely nothing happens; everything stays stuck in American. In the 'Display and Help Languages' section, I only have two choices: 1. Match Microsoft Windows (my Windows is also set to English) and 2. American. Obviously, I have option 1 selected, but there is no third option available.

I consider myself to be quite tech-savvy, yet I cannot seem to resolve this issue, so I’m asking someone more expert to step in and help before I completely lose my mind here....😢

Look, I know that if you want to switch from English to American, you need to have the American language pack installed. Now, if you have an American version of Office, it’s possible English is already there by default (which would make sense to me), though I can't say for certain. Given what you've described, you might not even have it installed, so go ahead and search online for the English language pack.

Anyway, Start -> Microsoft Office -> Language Settings.
You can change it there, and it will show you exactly which languages you currently have installed.

electrichawk4 said:Can anyone help me out with this...? Somehow I managed to disable the page count indicator at the bottom of my screen in Word 2003 (you know, where it shows something like 3/10), and now I have no clue how to get it back. To be clear, I don't mean the actual page numbers on the document itself, just that little status indicator at the bottom showing my current position. Thanks in advance!

Look, I don't even run Word 2003 anymore, so I'm going off pure memory here,
Tools -> options -> view tab -> status bar

My guess is you accidentally toggled off the status bar entirely. Give that a shot and let me know if it works. 😉

It’s been a while since I sat down to watch Pirates of Silicon Valley, but honestly, it wasn't half bad.
I actually found the way they portrayed his dynamic with Bill Gates quite compelling.
It really makes me wonder, though—do they dive into how he was tripping on LSD back in his younger days? 😁

Patrick Martin said:John Carpenter and Donald Pleasence

Carpenter was also a huge fan of Kurt Russell.😉

I think this movie is absolutely top-tier, just like Borat.
It’s got that incredible sense of self-deprecation—it's just brilliant stuff.

Kevin Kern said:She's also married to Joel Coen, for what it's worth.🙂

Personally, I can think of one recent one that actually has some legs: Nicolas Winding Refn's Drive starring Ryan Gosling.

Well, look at that—I had no idea.🙂

That reminds me of another one:
Luc Besson and Jean Reno

And then you have that director-composer duo:
Luc Besson and Eric Serra

The Coen brothers and Frances McDormand—she’s practically a staple in almost all of their films.

Yeah, you’ve got a point there, but I think there’s been a massive misunderstanding because Nicholas King was talking about the formatting, not how you actually input the data. And what you said regarding the grammarians? Spot on. They insist on certain grammatical cases for dates, which is a total nightmare to handle in Excel. You can easily set a format to show "July 17," but if you wanted it to read "July 17th" in a specific linguistic sense, you'd have to dive straight into VBA code just to make it work properly.

Exactly. At its core, a date is just a number—specifically, the count of days elapsed since January 1, 1900, if my memory serves me right. How we actually choose to display that value within a cell is entirely up to us. Personally, I tend to use the date format exactly the way Nicholas King suggested; it’s the most reliable way to get everything back into a standard American date format that actually makes sense to the eye.

For me, originality is the absolute bedrock of any good movie. Don't get me wrong—direction, acting, cinematography, all that jazz is obviously essential—but if the core concept is hollow, even the most polished directing won't save it from being a dud.

When it comes to remakes, I basically give the premise a zero out of ten right out of the gate. That’s why I can't stand them; it feels almost impossible for a remake to ever top the original. Sure, they might have better production value or look sharper on screen, but since the idea itself is just a recycled shadow of what came before, the whole experience feels cheapened. At least in my book, a lack of vision automatically tanks the entire rating.

hollowmaker11 said:I really want to thank everyone who took the time to help me out or even just tried to wrap their heads around what I was dealing with.

First off, a massive shout-out to frozenheron7 for actually getting this sorted for me. Seriously, I can't thank you enough—you saved my skin and let me finally get back to work without this headache hanging over me. 😍

Happy to help! 🙂

No... 🙂

Honestly, I’d love to see some kind of federal law passed that just bans remakes of the classics altogether.

And don't even get me started on the music industry—they do the exact same thing there.

But this? This right here is genuinely crossing a line. It’s gone way too far.

crimsondriver37 said:Is there any way to set up an inventory system in Excel for running a bar? Like, is it even possible to make it so that when I log one cocktail, it automatically breaks down the ingredients and deducts them from the current stock levels?

Just thinking out loud here, but you could probably pull that off using some complex nested IF statements. Honestly, though, it would be a hell of a lot easier to just slap a button on there and program a tiny macro with a few lines of code to handle the heavy lifting.
Can you send over the Excel file—or at least the specific part you're working on—so we can take a look?

Though, if you really want to do this right, a proper database is the way to go. Microsoft Access is probably your easiest bet for keeping things organized.

I’m not entirely convinced you can actually define a keyboard shortcut directly through the code itself.

However, there is a distinction in Excel regarding where a macro lives—it can either be stored globally within the Excel application itself or tucked away solely within the specific workbook you're currently working in.
It’s possible that your macro was recorded at the application level, which would explain why it seems to trigger across every single file you open.

If you save the macro directly into the workbook instead, it becomes portable and stays with that specific file; that might just be the root of the issue you're seeing.

Carol Rivera32 said:here is the link: http://www.sendspace.com/file/xjly5f

The very last cell in the total cost column should be summing up all the cells directly above it.
Unfortunately, I can't upload the entire document, but I'm hoping this snippet is enough...

Walter Jackson48, look, I’ve got newer versions of Office (both 2010 and 2013), but I am completely lost trying to find where the security settings are actually defined.
Do I need a whole new tab? Because I don't see that sequence anywhere (not even in Visual Basic): Tools, Macro, Security, then Median or Low?
And besides, shouldn't the person receiving the document be the one handling those settings, rather than me? 🤷
I'll admit, I'm totally out of my depth here. 🤷

I downloaded it and it works perfectly fine for me. 🙂
The only thing I had to do was right-click -> update field on that final cell.
I'm running the 2013 version.

^
I've found myself stuck in this exact same mess more times than I care to admit—trying to pull CSV files into Excel when the database is using American number formatting.
Like Jack Hayes mentioned, when you're importing (you go to the "Data" tab, then under "Get External data" -> From Text), you can actually specify the data type for each column. My trick is to set any columns containing numbers to text format right away.

After that, you just run a Find / Replace. You’ve got the "Replace All" button right there, so you don't have to waste your life doing individual replacements; it swaps everything in the document in one single click.

Now, if you're dealing with decimals, you absolutely have to use a placeholder—some third, random character during the replace process. I personally always use the @ symbol because I know for a fact it won't show up anywhere else in my data.
For instance, if you have a number like 5,258.56 that needs to become 5.258,56, you can't just swap the comma for a period. If you do that, you'll end up with 5.258.56 and completely screw up the value.
So, here is the workflow: first, replace the comma with @ (leaving you with 5@258.56), then replace the period with a comma (giving you 5@258,56), and finally, replace that @ with a period (to get 5.258,56).
I'm telling you, just use "Replace All" and the whole thing is sorted in a few clicks.

If you're only dealing with integers—just plain old whole numbers—and you simply want to strip out the period, just put the period in the "Find" box, leave the "Replace" box empty, and hit "Replace All." The periods will vanish.🙂

Once that's done, just highlight the columns you need and set the formatting to number.

driftingbear29 said:

🍿 Can we just make this thread about everything that gets under our skin? 😍

Brilliant. 🙂
Here are a few more pet peeves for the pile.

Instead of bakeries, or even better, local shops, everywhere I look I see this nonsense word "pekarna"—a term that doesn't even exist in the American dictionary (at least as far as I'm concerned).
In Finland, they actually have laws that penalize spelling errors on public signage, posters, and so on. Honestly, I'm all for it, because it affects everyone who has to walk past them and read them. If that were the case here, 90% of our local bakeries would be slapped with a fine and forced to change their signs immediately.

And don't even get me started on sports broadcasts or news articles; I constantly see things that drive me up the wall, specifically when people slap the prefix "most" onto words that are already superlatives.

For instance, saying something is "most dominant" or "most ideal."
The other day, I saw a headline on Index that read "FC Barcelona was more dominant than Real Madrid." What is that supposed to mean? That Real Madrid was dominant, but Barcelona was somehow... "more" dominant? It makes zero sense.

I seriously have to wonder if they're even hiring actual journalists anymore, or if journalism schools even offer courses like "Basics of American language" or "Culture of American language" or anything of the sort. The mistakes these reporters make—when language should be their primary tool and weapon—are absolutely egregious.

driftingbear29 said:

Pro 😂

Yeah, I noticed—the second you got what you wanted from my first post, you were already moving on. 😁
Honestly, women... it’s always the same story. You get exactly what’s on your mind, and then you just toss us aside without a single thought for how we actually feel. 😁