Posts by Dana Diaz8

Sophia Thompson41 said:Is there any way I can print this document so that everything looks exactly the way I formatted it in Word 2003?

Try downloading a PDF writer (most are free). It works like a PDF converter, but you actually install it on your computer as if it were a physical printer. You can tweak all the settings just like any other printer you have plugged in, but the end result is just a PDF file saved to your hard drive. Once you have that, you can take it to a print shop and you shouldn't run into any issues. If that doesn't work, then honestly, you probably didn't get your image alignments right in the first place!

Larry Peterson30 said:Hey there,

I was wondering if this is actually doable.

Do a little digging on Google; you'll probably find exactly what you're looking for...

Patrick Sanders91 said:Hey, any idea how to tackle this problem?
http://i45.tinypic.com/2n6b22q.jpg

Writing out the whole thing would be way too much work, and honestly, since this looks like some textbook assignment, there's probably a teacher or instructor who provided specific study guides or handouts to go along with it. Maybe this might help you out: http://accesstutor.tripod.com/4.htm

If your English is up to par, you could also try checking this out: http://www.online.tusc.k12.al.us/tut...s/accquery.htm

🤷

Dennis Sanchez84 said:I’ve got a question regarding Microsoft Office.

Now that I've finally wrapped up my thesis, I need to put together a table of contents, and I'm hitting a wall.

I just can't get the page numbers to line up vertically—you know, actually stay aligned under one another.

I'm using the latest version of Word, and honestly, I can barely navigate this thing. :/

Did you actually set up your titles and subtitles using headingsb>? Because if you didn't, that's your problem right there. You need to go back and change all of them to headings first. Once you've done that, just search Google for how to create a table of contents in Wordb> and follow the steps. If you do it correctly, the content should align perfectly on both the left and right sides, and it'll even automatically pull the styles and fonts you used for your headers. I'm still stuck using an older version from years ago, so I don't know the exact clicks, but the logic for generating a table of contents hasn't changed much since the early 🤷 2010s
version.

granitepilot342 said:I need help, fast! I'm using Word 2010 and I absolutely cannot find where the Greek letters are hidden. I've tried everything under Insert Symbol, but nothing works. I specifically need to insert the letter xi! Also, does anyone know how to add standard deviation to an existing chart? I have a bar chart with three columns, and each one needs its own error bar showing the deviation from the base value. Please help, this is urgent!

For the first part, try changing your current font—say, Times New Roman—to Greek Math Symbol. Once you've done that, just hit the "e" key on your keyboard and the Greek letter xi should pop up. If it doesn't, you might just have to cycle through the rest of the keys until you stumble upon it.

As for the second part, I honestly have no idea what you're looking for, so I can't really offer any guidance there.

George Fox23 said:Hey everyone,
I'm hitting a wall here and I can't make sense of this, and I need it fixed immediately for some calculations I'm running.
Why is it that when I type 24840083200735935 into a cell formatted as a number, it just forces it to 24840083200735900?
No matter what I try, it keeps overwriting it like that.
What am I missing here?

It's because Excel has a 15-digit precision limit. Basically, you can only input 15 significant digits per cell, and since you're trying to pack 17 in there, 🙂

restlesstiger102 said:Let me repeat what I actually need:

1. The first four pages shouldn't have any page numbers at all.
2. Page five should be numbered, but it needs to start at 5, not 1.

Sorry for jumping into this mess!!!

Everything you’re looking for is clearly explained in the link provided (I made sure by reading the whole thing myself), so I honestly don't know how you and these "others" you mentioned can't figure it out. Is it possible people are tripping up on steps 6 and 7? That’s where most folks stumble—you have to uncheck link to Previos from every single page, not just the one where you want the numbering to begin. You might want to take a closer look at that part. As for the second issue, all you have to do is hit the "start at" option and type 1 instead of 5 (the link tells you exactly how to find that menu).

Samuel Green80 said:Hey there..
Can someone explain what kind of formatting I should use to round a number in a cell to two decimal places, but if the second decimal is zero, it rounds to one, and if both decimals are zero, it just displays the whole number without a decimal point? Here’s an example if nobody understands me..
My custom format is currently " 0.## ". So 2.67 shows up as 2.67, 2.60 shows up as 2.6, but 2.00 shows up as 2. . What I actually want is for 2.00 to show up as 2 (meaning, no decimal point at all)

I don't know how to handle this via formatting, but I do know how to fix it without using formats at all—just by using a formula. You can then eventually copy and paste them (paste special - values) into a new Excel sheet if having two columns bothers you. Whether that's a satisfying enough solution is anyone's guess. :not_sure:

Here’s how I pictured it: you have your set values in column A, which could have infinite decimals, but you want Excel to display a whole number if it's an integer; otherwise, let it display the number with two decimals (in my case, the order of conditions in the formula is reversed). You just copy this formula into column B:
=IF((A1-INT(A1))<>0,ROUND(A1,2),INT(A1))
The formula works like this: if the difference between the given number and its integer value is anything other than zero, Excel will display that number rounded to two decimals; otherwise, it will just give you the integer.
The downside to this formula is that you lose some precision. For instance, if you have the number 2.656 and tell it to round to two decimals, Excel might end up showing 2.65 when it really should be 2.66. But hey, if you need to solve that too, it's not impossible...

Sorry to crash this discussion, but maybe I can shed some light on this. As far as my understanding of statistics and testing goes, using an Excel Formula like STDEV works just fine if you're dealing with ungrouped values. However, if you're working with grouped data, you have to approach the solution step-by-step, exactly like the method someone else described in that image they posted.

Gregory Evans5 said:For instance, I want to jump straight to the letter M.

This might be a bit much for some of you to wrap your heads around, but if you actually have the willpower, you can probably fix this mess yourself!!!
If you're running Microsoft Word 2007, check out this link
If you're still stuck using an older version, try this one

Both of these links explain how to properly set up a Table of Contents in Microsoft Word. Right now, your headings are just showing up as A, B, C, D, E, F....Z. Once you manage to get the Table of Contents working correctly, head over to this link http://office.microsoft.com/hr-hr/wo...65929.aspx#BM3. It walks you through how to create hyperlinks within an existing document. The whole point is that when you click a specific entry in your table of contents, Microsoft Word will instantly jump you to the exact page you linked to.

Good luck!

frozenraven10 said:Thanks a ton!
Now I'm running into a different headache. I want a function that counts how many specific conditions have actually been met. Here is what I tried attempting:

=COUNT(IF(U22>W22;IF(W26>U26;IF(U30>W30😉))) but it’s just not working...

Does anyone here—or maybe someone else out there—know how to pull this off?

I'm a bit out of the loop here and haven't quite grasped the context, but maybe one of these will do the trick:
=COUNTIF(Range; Criteria) - counts cells in the Range that aren't empty and meet the specified Criteria
=COUNTA ( ) – counts all non-empty cells

driftingpilot8 said:Hey there,

I need some help. I have two columns in Excel that are supposed to have the exact same number of rows.
Is there a way to find the discrepancies and highlight them somehow?

Can you clarify what you mean? 😕

From what I gather, you’ve got two columns—or maybe two separate sets of data—and you need to compare them against each other. But here’s my question: how exactly are we comparing? Are we checking if one whole column matches another whole column, or are we looking at specific individual values row by row? 😕 If you're just dealing with numbers, why not just sum up both columns separately? If the totals don't match, you've found your problem. Otherwise, tell me exactly what you're trying to achieve and what the comparison logic should be, and I'll see if I can actually be of any use to you.

Jessica Brown25 said:I click to enable page numbering, everything looks perfect at first glance, and every single page actually shows its own number.

Fine, if we aren't doing this my way, let's just go "by the book." Seriously. Just do exactly what I told you, but don't go deleting any numbers. Instead, try this: if you're looking at numbers in the footer, then... Wait, did I miss something? Is there a second part coming, or was that it? Double-click directly into the footer on the page, then dig through the options until you find the setting you're looking for. It’s all in there. Link to the Previous SectionGo ahead and click that. You’ll want to follow the exact same steps on the third page as well. Once you're done with that, give it a shot and try deleting the page numbers. 😍 As for the second part regarding the text, it’s the exact same deal. Just click on the header at the top of the page, select "Link to Previous" again, and then go ahead and delete everything you don't actually need. Why make it more complicated than it has to be?

Jessica Brown25 said:So, like I said in the title...

From what I can gather, you're dealing with two distinct headaches:
1. Getting rid of page numbers on the first two pages.
2. Starting the numbering from a specific number on a random page.

The first issue is solved by splitting your document into two sections using a page break at the end of the second page. Your first section will cover those initial two pages, while the second section will handle everything else starting from page three (you'll need to use a continuous page break at the top of page three). Once you've successfully split the document into two sections—which you'll know you've done if you double-click the header or footer—you can tell Microsoft Word to insert page numbers. Sure, it’s going to slap a number on every single page at first, but since you've partitioned the file into sections, you can just click into that first section and delete the number. If you did everything correctly, the numbers should vanish from the first two pages and pick up normally starting on the third...

As for the second part, here is how you handle it: let's say instead of page 3 showing "3," you want it to show "15" for some reason. In the menu where you go to insert page numbers, look for the "Format Page Numbers" option. Click that, and a window will pop up where you can select "Start at." Just type in whatever number you want (in our case, 15)

urbanbison8 said:And finally, I’m adding a formula to sum everything up for the total hours, and everything seems fine.
Now, how can I make it so that when I type a word like "Go" (vacation) instead of a number, Excel actually recognizes that word as the value 8 (eight hours) and includes it in the hourly sum?

Maybe this will help you :confused:: I usually work with a dummy cell (A1), and since you have a larger dataset, you can just apply the same logic by changing the cell reference... You can set up a formula like =if(A1="go";8;A1). The only downside to this approach is that you have to tuck the formula away somewhere next to your table or on a new Sheet2, sum those results there, and then plug that final number into your main table (specifically where you mentioned: ''And finally, I’m adding a formula to sum everything up for the total hours''). Otherwise, here is what the formula does: if the specified cell (A1) contains the word ''go'', Excel spits out the number 8; if that word isn't there, it just keeps whatever was entered (like 4, 5, 6, 7, 8 hours, or whatever number you need).
Note: The " symbol is just standard quotation marks from your keyboard using shift+2.

Ryan Hayes82 said:Does anyone know how to take one large PDF and turn it into two smaller ones? Basically, can I just split this PDF into two separate parts?

Look, this isn't really what this thread is about, but here's my two cents. Just type pdf split online free into Google and see what pops up. Honestly, just find the tool that works best for you—specifically, look for one that doesn't demand your email address just to function. You want something where you upload the file, get it processed, and download it immediately without all the extra nonsense!!!

Olivia Booth27 said:I'm struggling to link my tables in Access—specifically when trying to set up Enforce Referential Integrity.

The real headache is I have no clue which specific conditions need to be met to actually achieve Integrity.

I keep getting hit with this error: "no unique index found for the reference field of the primary table."

Does anyone actually know what's causing this?

You probably don't have a primary key set up to link those tables. Either create one yourself or just let Access handle it automatically... Honestly, that’s usually where the breakdown happens.

John Cooper65 said:Hey everyone, looks like I’ve run into a bit of a snag too.

Look, the tasks you're struggling with are basically Excel 101—stuff middle schoolers pick up in their first computer lab session. Honestly? That makes you a beginner. If someone just hands you the answers, what's the point? You won't learn a thing, and you'll be completely lost when the actual complex stuff hits your desk later on. If you want to actually learn, check out this link: http://www.microsoft.com/en-us/office/excel2003/excel38.html It lists all the commands used in Excel 2003, which work perfectly fine in any other version of Excel, too. Now, the ball is in your court. Are you going to actually study this and figure it out, or would you rather just send a deposit to my bank account? If the cash clears, I can have those solutions in your inbox within five minutes. Your call.😂

slyviper6 said:So, here's the deal: I was working on a paper in Microsoft Word (about 14 pages long) and I've hit two snags.

The first issue is that I jumped straight into Chapter I on the very first page, but I actually needed an introduction there.
Now I'm stuck—how do I squeeze that intro in so it sits on page one, leaving Chapter I for page two?

The second headache is that the spellcheck isn't catching my mistakes, which I know are probably there (like if I accidentally type Froum instead of Forum).
Is there some little utility for this, or can I just tweak the settings in Word itself? Or am I doomed to fix everything by hand?

😕

First off, which version of Word are you running?
If you're using the 2007 version, just put your cursor at the very beginning of your text, go to Insert -> Blank Page, and a fresh page should pop up right above your work... Alternatively, you could just stick the cursor at the start and start typing your intro; everything else should just shift down automatically.
If you have the 2007 edition, you likely don't have the American English dictionary installed, which is why Word isn't flagging anything! You basically have two paths: buy an official language pack upgrade from an authorized Microsoft Office site, or just head over to this website, paste your text in, and let it highlight your errors. Here’s the link: http://www.grammarly.com/. It'll flag all the typos with green boxes, and if you click them, you'll get a menu to pick the correction you want!

Larry Peterson30 said:Hey there,

I'm putting together an Excel sheet to act as a tracking log.
The problem is, the colleague who’ll be handling the data entry isn't exactly known for her precision or reliability. I need one specific column to have perfectly consistent formatting so I can actually filter the data later once it gets imported into another program.
To fix this, I want to set up a drop-down menu for each cell in that particular column so she's forced to pick from a list instead of typing things in manually. All the other rows should function normally, just like they do now.

Is this doable, and if so, how do I pull it off?

Thanks in advance,

This should point you in the right direction: