You could probably write him a letter in code and he'd still pick up what you're putting down. He managed to build tracker software in just four days. The guy is widely considered a total computer genius.
Everything's sorted now. Link. I had to get my cell formatting dialed in before I actually typed the number in, not the other way around. Does that make sense?
Thanks, everyone! 👍
Walter Jackson48 said:If you're building that chart based on cell B1 (which was my first post in this thread), then it should be showing $45.60 M above the "beam" of the chart, whereas in your case, it's displaying $45.00 M. The only real issue here is that if we aren't given enough details, we're just left guessing what you're trying to achieve before we can even offer a solution.
Walter Jackson48 said:Try using $#.##0,00" M" under the custom settings.
You should obviously apply this to the values on your chart. Give it a shot. Scales? Are we really still debating the basics? Set the Max on the y-axis to 50.
Is it really that hard to understand why it keeps spitting out the full number followed by an "M"? $4,500,000.00.
Thanks, but I actually need the code for cell formatting. Under Custom, General. I've already messed around with a few different codes, but it keeps spitting out things like "4.5 M USD," "4.5$ M USD," or "$4.5 USD," yet I just want it to show "$4.5 M."
How do I set up my Excel so that instead of showing $40,600,000.00, it just displays $40.6M, all while making sure my chart doesn't get completely messed up?
Melissa Hayes41 said:Bravo, you hit the nail on the head, that's exactly what I was thinking.🙂 It's just that specific page doesn't work for me because the templates are too limited. I'll try to dig deeper into this "Cloud" thing you mentioned. Thanks.🙂
The Cloud is just how they built the site, or maybe it's the type of platform, I'm not entirely sure. There aren't really any other sites for making these kinds of presentations, unless you count the ones used to make things similar to PowerPoint. You can even build your own template on prezi.com if you want; why bother using theirs?
Melissa Hayes41 said:No... I can't quite find the right words to describe it, but it was like this: the first slide would just show treetops, and then when she clicked to the next one, the view would "pan" down to a branch so the branch ended up in the background... basically, the slides were traveling along the tree 😁 that's the best way I can put it 😁
Visit www.prezi.com I think that’s exactly what you're describing.
They have tons of presentations like that there. They're popular, and they aren't exactly hard to put together. That said, they definitely have their flaws—you can't use italics, you can't add audio, and you're stuck with whatever fonts they provide instead of picking your own; plus, all the presentations tend to follow that same repetitive style.
It isn't Flash or PowerPoint. People mention some kind of "cloud" system, though I'm not entirely sure how that works.
If you're a student, you can probably snag a premium account through your school credentials. If not, you'll just have to stick with a basic account, but keep in mind you won't be able to protect your work, meaning anyone can just rip it off.
Melissa Hayes41 said:Hey everyone. I’m pretty comfortable using PowerPoint, but I really want to figure out how to use it within Flash—or at least, that's how I think it works. A girl in my college class showed off this presentation that was absolutely breathtaking. It looked like a tree where the branches would shift and grow as she moved through the slides; instead of just flipping pages, it felt like we were traveling along the branches with every click. Everyone was stunned by the design, and when my friend asked her later, she mentioned she did it in Flash. Now, I'm not sure if I actually remembered that right or if I'm totally confused. If I'm on the right track, could someone please walk me through how to do this? Thanks 🙂
mistybear522 said:Hey everyone! I just had some custom envelopes printed for my small business featuring our logo and address, and now I want to set up a template in Word so I can easily print out recipient names and addresses. It seems like it should be a breeze, but I can't seem to get anything to work the way I want. So, in Word under Mailing there's an Envelopes option where you enter the recipient's info and tweak the settings. What I'm looking for is to have the recipient's address sit in the bottom right corner, which is how we usually format them here in the States. But no matter what I try, the layout is a mess. It either ends up centered, upside down, or—most frustratingly—the printer runs through the envelope and spits out a completely blank sheet. I've been messing with the "envelope options" to adjust the address position and the "feed" setting, but nothing sticks. What am I doing wrong?
If you're dealing with an image, you need to make sure the image wrap is set to "behind text." If it's sitting on top of the text layer, the program isn't going to let you type over it.
Run a virus scan on your PC, or just wipe it and reinstall Office. I dealt with much worse glitches back when I was using Office 2007. Every single time I hit Ctrl+S, the window would just vanish, wiping out everything I had typed without warning. Since my muscle memory keeps forcing me to hit Ctrl+S, how many times do you think that actually happened to me? At least ten. The only way I fixed it was by performing a clean install of Office on a fresh OS.
The page break is forcing everything onto a new page. It won't let you keep typing on the current one; instead, it just jumps straight to the next. There’s a section break involved here. You can find it under Page Layout.
I did a little more digging. It turns out the template—or at least its core components—was actually built in Photoshop. According to the creator, you just can't pull off that specific look in PowerPoint because the layers are too complex, especially with all those shadows and outlines.
Sure, if they’re claiming 16 GB or 32 GB capacities right out of the gate, you should definitely be suspicious. Then again, those higher capacity ones actually exist, they just come with a much steeper price tag.
I ended up grabbing a Transcend 4 GB drive for about five bucks. It works perfectly fine, and it even glows blue when I plug it into my PC.😁
As for what you mentioned, lifetime storage means exactly what you thought it meant.
Just exit that dialog box and save it the way you normally would. It’s probably showing up as Read-Only because the document is already open, and you're trying to copy a file onto itself while it's still active, right? If you want to keep the original version untouched while saving a new version under a different name, you should be using "Save as". Are you still running 2003?
Here’s a new headache for you. Does anyone happen to know an Excel formula that would let me increment a number in a column—say, column N—but have everything automatically adjust itself if I end up deleting a row? For instance, if I'm typing out a sequence like 1, 2, 3, 4, 5, 6, and then I delete row three, wouldn't I want the remaining rows to shift up and maintain a perfect 1 through 5 sequence, so that when I finally add a new row at the bottom, it just automatically assigns itself the number 6?
I find it honestly a bit unsettling when people feel zero urge to keep houseplants. In my view, every single person ought to have at least one plant in their home. What’s your take on that?