Posts by Walter Jackson48

Betty Hayes10 said:Everything is sorted out now.

Thanks, everyone!

A little bit from everyone, but you really went above and beyond—there's the fix.

Betty Hayes10 said:It spits out a full number followed by the letter M:
$4,500,000.00 M

Look, if you’re building that chart based on cell B1 (which was my first post on this whole thread), then the top of the bar should be showing $45.60 M, which means in your specific case, it ought to read $45.00 M.
The only real issue here is that we aren't getting enough info from you. We're basically flying blind, guessing what you actually need, and then throwing solutions at the wall to see what sticks.

For the custom format, try using $#,##0.00" M"

Just make sure you apply this to the values on your chart.
Also, give this a shot: go into the scales and set the Max on the y-axis to 50.

If you go ahead and punch $46,600,000.00 into cell A1, then just pop this into B1:

="$"&MID(A1;2;13)/1000000&" M"

p.s. Just realized I was looking at a chart... typical me.

Tyler Wood43 said:Hey everyone!

Look, in column C—specifically that value sitting at 7.35E+6—you’ve got the decimal point wrong. You need to swap that period for a comma, basically
typing it in as 7,35E+6

Look, there isn’t any problem out there that doesn't have a solution, but you have to realize that the real catch is being able to actually
define what the problem is.

Look, just try running these formulas—and don't forget you have to put an "=" in front of them if you want anything to actually happen:

http://i45.tinypic.com/2uqd34n.jpg

Alright, here is the formula—let me know if this actually does the trick for you:
(toss this formula into cell B1)

=IF(AND(A1>=18,A125,A1
Look, this setup works if you want to dump all those numbers into one single cell (in my case, I’m using A1). It’ll spit out the labels—like "First," "First and Second," "Second," etc.—right there in B1. Now, if your goal is to distribute these intervals into separate cells instead, you’re probably going to only need a specific slice of this formula.
To break down what's happening under the hood: if A1 is 18 or higher AND less than 25, it says "First." If that isn't the case, we then ask if A1 equals 25, and if so, it writes "First and Second," and so on. Honestly, though, the way these intervals are set up feels a bit wonky to me. Having one group from 18-25 and another from 25-31? Statistically speaking, it would make way more sense for the second group to start at 26. But hey, you clearly have your reasons for setting it up this way.

Maybe you should try jumping into the Print Preview first, then switch over to the page break preview so you can actually see how your pages are laid out—basically, where those horizontal lines are sitting on the pages. If they’re cutting off right in the middle of a sheet or just look completely wonky, just hover your cursor over that line until it turns into that double-sided arrow icon, and then just "drag" it all the way to the edge of the page. Does that fix it?

Well, obviously, you can't exactly print out something that doesn't exist in the first place. It sounds like a no-brainer, right?
At the end of the day, the main thing is that the issue is finally sorted, and hey, we picked up a little something new along the way.
Best,

Honestly, I haven't the slightest clue what's going on with your setup because, for some reason, everything is running perfectly fine on my end.

Amanda Barnes7 said:Hey, I'm trying not to start a whole new thread here, but...
does anyone actually know how to print four tiny little pages onto a single sheet of US Letter paper?

Just go to File, then Print, hit Zoom, and look for the 4 pages option under Pages per Sheet. Once you find it, just hit OK. That works for the older versions like 2003.

If you can't get it to work through the standard Print menu, try heading into the Zoom settings. Look for Page Scaling, set the paper size, click that little dropdown arrow, and select Letter. That should do it.

My apologies, I misspoke there. I was moving too fast and misread the thread—this is actually about Word.
For those working in Excel, give this a shot: go to Print, then Properties, hit Landscape, and head into Advanced. In the Paper size field, just pick Letter and hit OK. Hopefully, that solves the issue for you.

stormycanyon13 said:Is there any way I can have two Excel files open at the SAME TIME from the same folder but in SEPARATE windows??
If the answer is yes, how do I actually set that up in the settings?
thanks

Look, it’s not even a setting you change in the menu; it’s just how you handle them. Just open your folder, launch the first document, then minimize it—tuck it away down at the bottom. Then go ahead and open the second one. Once both are running, head up to the Window menu, select Arrange, and check the box for something like Cascade. Hit OK, and boom—all your documents are laid out right in front of you in a cascade. If you want to see a specific file that’s being covered up by another, just click on it and it’ll pop to the front. You can do this with a whole stack of files, really, just don't minimize that very last one... leave it sitting there in its Window so you can actually work on it.

steelbison14 said:I have a quick question regarding... Word

Give this a shot—I'm still running an older version of Windows here, but the logic should hold up. Go ahead and open up your My Documents folder, then head over to Tools and pull up Folder Options. From there, navigate to File Type, and just give it a second to load. Once you're looking at the Registered file types, hunt down that .DOC extension. Click on it, and right next to "Open with:", it should show Word. Just hit Change to confirm everything, then click OK and you should be good to go.
I’d bet my last dollar that things were pretty much the same back in 2007. Everything just repeats itself, doesn't it?
P.S. This kind of mess usually happens right after you go and install some sketchy software or similar programs that just aren't worth the headache.

Amy Gray52 said:Hey there!!!

I've got a question regarding Excel:

Take a look at this if you think it might help, though I suppose
this has already been covered somewhere else:
http://www.datafilehost.com/download-15d47f83.html

Take a look at this; it might actually be useful for you:

Formatting, Paragraph settings, Line spacing... yeah, all good. Back in '03, we were already set.

Maybe try it this way:

Go to Format, then Sheet, then Background, and just drop in whatever image you want there.

Taylor Patel2 said:I just want to be able to format a cell in Excel so that when I type 1701 and hit enter, it actually shows up as a date like 01/17/12.

Give this a shot:

Put the number 1701 in cell A1, then go over to B1 and drop this formula in:
=IF(A1<>"";LEFT(A1;2)&"."&MID(A1;3;2)&"."&"12"&"." ;"")
Once you hit enter in B1, it should spit out 01/17/12. If you drag that formula down from B1 to, say, B10, and then start typing your numbers into the A column, you’ll get exactly what you’re looking for.
If you actually want the full year displayed—you know, like 2012 instead of just 12—just swap out that "12" in the formula for "2012". Good luck.