Posts by Nicholas King

Charles Murphy78 said:On top of that—if I ask it to sum one number from the "old" section and one from the "new" section—it just won't work. For instance, if I try =SUM(I2696;I2697), the result is just the number sitting in I2697; it seems like it's treating I2696 as a zero. So, if anyone happens to have an idea about what might be causing this... I'd really appreciate it........

It's highly probable that Excel is seeing those "old" values as text rather than actual numbers—maybe check if they're left-aligned in the cell, whereas the "new" ones should be right-aligned?

Try doing this:

1. In any blank cell, enter the value 1.
2. Select the cell in which you typed 1 and click Copy on the Edit menu.
3. Select the cells with the values that you want to convert to numbers.
4. On the Edit menu, click paste special.
5. Under Operation, click Multiply. Under paste, click Values, and then click OK.

Charles Murphy78 said:First off, thanks for the help—I'm sure it'll work out once I actually figure out how to apply this formula you're giving me. Here is what I tried to do: My dates are in column A, starting from A2 and going from A2 to A2696—these are the ones from a hundred years ago—and then from A2702 to A2702 they look fine. I typed the formula into the cell right under the most recent date like this: =DATE(YEAR(A2:A2696)+100;MONTH(A2:A2696);DAY(A2:A2696))
But nothing happens, except that all the selected fields get outlined with a thin blue border and it tells me I've provided too many arguments in the formula. I suppose once you see my formula, you'll know exactly where I went wrong. I only started using Excel a few days ago, so I guess this is all still pretty foreign territory to me. Thanks, cheers...

Alright, let's take this very, very slowly. 🙂

- click on cell B1;

- Insert an empty column (Insert -> Columns)

- click on cell B2

- Type exactly like this =DATE(YEAR(A2)+100;MONTH(A2);DAY(A2)) and hit Enter

- click on B2 again (hitting Enter just drops you down to B3)

- notice the little square in the bottom right corner of the cell border; hover your cursor over that square (the cursor will change shape when you're over it) and "drag" (hold down the mouse button and pull downwards) the formula down as far as you need to go.

Now comes the part I already mentioned:

- select those "shifted" dates (that is, the range B2🙂2696) and Copy them.

- go to A2 and use Edit -> paste special -> Values

- delete that extra column B you added;

- head over to Ivanov's website and study, study, study... 🙂

Charles Murphy78 said:Thanks in advance for any help you can provide....

If I’m reading this correctly—and I might be wrong here, but I think I've got the gist—you're just looking for a one-time conversion. There's probably an even more streamlined way to handle this, though I suspect this method is the most reliable:

- first, open up a blank column where you'll calculate those shifted dates;

- assuming your "original" dates are sitting in column A, for instance, just type =DATE(YEAR(A1)+100,MONTH(A1),DAY(A1)) into that empty cell;

- drag that formula down as far as you need to go;

- highlight all those newly "shifted" dates and copy them;

- go back to the very first "original" date, then select Edit->paste special->Values;

- finally, just delete that extra column you created.

analogskipper742 said:Is there any way to stop two Microsoft macros from essentially overwriting one another?

It would probably be a huge help if you could just send over the actual macros. 🙂

You can just hit Ctrl/Shift/8—or, if you happen to be working in Word 2003, you might want to just click that little paragraph symbol button (the one that looks like an upside-down P)

Hannah Gomez5 said:Oh, please... so they just, what, calculate that number by hand somewhere off to the side???

Well, obviously—though by "by hand," I suppose she means using a Calculator or perhaps just setting up an Excel sheet.

Don't you think you might have simplified the formula just enough to once-off streamline an expression that ends up being calculated repeatedly over and over again??

Hannah Gomez5 said:you don't actually need the parentheses here

The formula in B1 would be 0.85*A1*1.23

Actually, you could just simplify the whole thing by combining those multipliers—B1=1.0455*A1

😁

Dennis Evans59 said:Where even is it? It’s not showing up in Program Files—honestly, I have no clue how to actually delete this thing. I'm running Windows 7, which is 😁

So, did you get into a fight with Google? Look, just buy them a coffee and apologize—I'm sure they'll be back on your good side in no time.

http://office.microsoft.com/en-us/wo...001121028.aspx

mistymarlin6 said:He’s back now, sure—but I still can't help but wonder what on earth was actually going on there.

Exactly.

Be afraid, be veryvery afraid. 😁

analogskipper742 said:I have a couple more questions: does this work for other system commands (like Ctrl+I or U), and will it function with custom shortcuts I've set up myself?

It works for italics, underlining, bolding, and paragraph alignment—but as far as I can tell, it won't touch any user-assigned keys.

analogskipper742 said:Unfortunately, no. Everything else seems to behave, but in F&R, it just won't cooperate—no matter what I try. If it’s working for you, or if you happen to know some trick to get it tuned correctly, please let me know.

I just double-checked in Word 2003, and it works fine with Ctrl/B.

Look, the text itself isn't actually being bolded; instead, you'll see a little "Format: bold" indicator appearing underneath it.

Kyle Johnson2 said:It wouldn't be a bad idea to just post that macro here on the forum—let people have it if it makes things easier for them (assuming it isn't some big secret 😉
.

So, here they are—divided into five groups based on the "type" of accent. I've set the macros up to trigger alongside certain function keys, and honestly, people tend to pick it up incredibly fast. I realize there are other ways to produce some of these characters, but in my experience—and this is just how I've found it works best—it's much more intuitive to just use something like this.

There you go. My Venmo handle is... 😁

****************************************
Macro for these replacements:

c ç C Ç e æ E Æ n ñ N Ñ a ã A Ã o õ O Õ
****************************************

Public Sub MAIN()

Selection.MoveLeft Unit:=wdExtend select Case Selection

Select Case Selection.Text
Case "C"
Selection.InsertSymbol CharacterNumber:=199, Unicode : = True Case Elsa Selection
Case "c"
Selection.InsertSymbol CharacterNumber:=231, Unicode : = True Case Elsa Selection
Case "E"
Selection.InsertSymbol CharacterNumber:=198, Unicode : = True Case Elsa Selection
Case "e"
Selection.InsertSymbol CharacterNumber:=230, Unicode : = True Case Elsa Selection
Case "N"
Selection.InsertSymbol CharacterNumber:=209, Unicode : = True Case Elsa Selection
Case "n"
Selection.InsertSymbol CharacterNumber:=241, Unicode : = True Case Elsa Selection
Case "A"
Selection.InsertSymbol CharacterNumber:=195, Unicode : = True Case Elsa Selection
Case "a"
Selection.InsertSymbol CharacterNumber:=227, Unicode : = True Case Elsa Selection
Case "O"
Selection.InsertSymbol CharacterNumber:=213, Unicode : = True Case Elsa Selection
Case "o"
Selection.InsertSymbol CharacterNumber : = 245, Unicode : = True Case Elsa Selection
Case Else
Selection.MoveRight Unit:=wdCharacter, Count:=1
End Select
End Sub

****************************************

****************************************
Macro for these replacements:

a á A Á e é E É i í I Í o ó O Ó u ú U Ú
****************************************

Public Sub MAIN()

Selection.MoveLeft Unit:=wdExtend select Case Selection

Select Case Selection.Text
Case "A"
Selection.InsertSymbol CharacterNumber:=193, Unicode : = True Case Elsa Selection
Case "a"
Selection.InsertSymbol CharacterNumber:=225, Unicode : = True Case Elsa Selection
Case "E"
Selection.InsertSymbol CharacterNumber:=201, Unicode : = True Case Elsa Selection
Case "e"
Selection.InsertSymbol CharacterNumber:=233, Unicode : = True Case Elsa Selection
Case "I"
Selection.InsertSymbol CharacterNumber:=205, Unicode : = True Case Elsa Selection
Case "i"
Selection.InsertSymbol CharacterNumber:=237, Unicode : = True Case Elsa Selection
Case "O"
Selection.InsertSymbol CharacterNumber:=211, Unicode : = True Case Elsa Selection
Case "o"
Selection.InsertSymbol CharacterNumber:=243, Unicode : = True Case Elsa Selection
Case "U"
Selection.InsertSymbol CharacterNumber:=218, Unicode : = True Case Elsa Selection
Case "u"
Selection.InsertSymbol CharacterNumber : = 250, Unicode : = True Case Elsa Selection
Case Else
Selection.MoveRight Unit:=wdCharacter, Count:=1
End Select

End Sub

****************************************

****************************************
Macro for these replacements:

a à A À e è E È i ì I Ì o ò O Ò u ù U Ù
****************************************

Public Sub MAIN()

Selection.MoveLeft Unit:=wdExtend select Case Selection

Extend : = wdExtend select Case Selection.Text
Case "A"
Selection.InsertSymbol CharacterNumber:=192, Unicode:=True
Case "a"
Selection.InsertSymbol CharacterNumber:=224, Unicode:=True
Case "E"
Selection.InsertSymbol CharacterNumber:=200, Unicode:=True
Case "e"
Selection.InsertSymbol CharacterNumber:=232, Unicode:=True
Case "I"
Selection.InsertSymbol CharacterNumber:=204, Unicode:=True
Case "i"
Selection.InsertSymbol CharacterNumber:=236, Unicode:=True
Case "O"
Selection.InsertSymbol CharacterNumber:=210, Unicode:=True
Case "o"
Selection.InsertSymbol CharacterNumber:=242, Unicode:=True
Case "u"
Selection.InsertSymbol CharacterNumber:=249, Unicode:=True
Case "U"
Selection.InsertSymbol CharacterNumber:=217, Unicode:=TrueCase Else
Selection.MoveRight Unit:=wdCharacter, Count:=1
End Select

End Sub

***************************************

***************************************
Here is a macro designed for these specific replacements:

a â A Â e ê E Ê i î I Î o ô O Ô u û U Û
***************************************

Public Sub MAIN()

Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend

Select Case Selection.Text
Case "A"
Selection.InsertSymbol CharacterNumber:=194, Unicode:=True
Case "a"
Selection.InsertSymbol CharacterNumber:=226, Unicode:=True
Case "E"
Selection.InsertSymbol CharacterNumber:=202, Unicode:=True
Case "e"
Selection.InsertSymbol CharacterNumber:=234, Unicode:=True
Case "I"
Selection.InsertSymbol CharacterNumber:=206, Unicode:=True
Case "i"
Selection.InsertSymbol CharacterNumber:=238, Unicode:=True
Case "O"
Selection.InsertSymbol CharacterNumber:=212, Unicode:=True
Case "o"
Selection.InsertSymbol CharacterNumber:=244, Unicode:=True
Case "U"
Selection.InsertSymbol CharacterNumber:=219, Unicode:=True
Case "u"
Selection.InsertSymbol CharacterNumber:=251, Unicode:=True
Case Else
Selection.MoveRight Unit:=wdCharacter, Count:=1
End Select

End Sub

***************************************

***************************************
Macro intended for the following replacements:

a ä A Ä e ë E Ë i ï I Ï o ö O Ö u ü U Ü
***************************************

Public Sub MAIN()

Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend

Select Case Selection.Text
Case "A"
Selection.InsertSymbol CharacterNumber:=196, Unicode:=True
Case "a"
Selection.InsertSymbol CharacterNumber:=228, Unicode:=True
Case "E"
Selection.InsertSymbol CharacterNumber:=203, Unicode:=True
Case "e"
Selection.InsertSymbol CharacterNumber:=235, Unicode:=True
Case "I"
Selection.InsertSymbol CharacterNumber:=207, Unicode:=True
Case "i"
Selection.InsertSymbol CharacterNumber:=239, Unicode:=True
Case "O"
Selection.InsertSymbol CharacterNumber:=214, Unicode:=True
Case "o"
Selection.InsertSymbol CharacterNumber:=246, Unicode:=True
Case "U"
Selection.InsertSymbol CharacterNumber:=220, Unicode:=True
Case "u"
Selection.InsertSymbol CharacterNumber:=252, Unicode:=True

Case Else
Selection.MoveRight Unit:=wdCharacter, Count:=1
End Select
End Sub

***************************************

Kyle Johnson2 said:I didn't even think to 😉

Well, I didn't either—it’s buried away in the Insert -> dialog symbol menu. 🙂

Personally, I just handle all of this by using macros assigned to specific function keys. I’ve set up one for every single type of special character... so, for instance, if I need á, é, ó, or í, I just hit a(F9), e(F9), o(F9), or i(F9), and so on. It's much more efficient, I guess.

boldcrane6 said:Is there really no straightforward way to just type an ã—you know, like hitting a specific key combo on my keyboard 😁?

Ctrl/Alt/1 A

boldcrane6 said:Hey everyone! 🙂

I have a bit of a question—it might be a totally silly one, but what can you do 😁—how on earth do I get these diacritics (like ~ ˇ ^ ˘ ˛ ` ˙ ´ ¸) to actually sit above or below a letter?
In Microsoft Office Word, I’m trying to type a specific character, say (ã), but instead of it working correctly, it just displays as a separate ~ and an a.

Does anyone know how to properly combine these accents with letters?

Thanks. 😍

Go to Insert->dialog symbol->Normal text and just pick the one you need. Another way—though it’s honestly a massive pain in the neck—is to just copy and paste them from the Character Map.

If you find yourself needing these all the time, it might be worth setting up a little macro—for instance, one where pressing 'a' automatically converts it to 'ã'—and then assigning those macros to some function keys.

Kyle Johnson2 said:From what I can gather—and I might be misinterpreting here—@rustycrane86 didn't actually mention anything about "printing"; he was specifically asking about saving files in *.jpg format.

"Tables in JPG format are required when publishing papers in academic journals."

Kyle Johnson2 said:You could just hit the "Print Screen" key, then use "special pasta" in Word—or maybe some graphic software like Corel PaintShop Pro or even just Windows "MS Paint"—and you'll get an image quality identical to what you see in Excel.

Not really. 🙂

He’s basically stuck with whatever resolution his screen happens to be at—which, in my experience, is often nowhere near sufficient if you're looking for anything resembling serious print quality.

rustycrane86 said:I was wondering about all the different ways one could save an Excel spreadsheet—or just a specific worksheet—as a JPG image, while somehow maintaining the exact same layout and quality as if it were saved directly as an XLS file.

You’re always going to lose some level of quality when you do that.

Honestly, why would anyone even want to do something like that in the first place? 😕

Karen Cook51 said:Wait, what do you mean by "how"?

- Set up three distinct sections (start without page numbers, middle section with them, and an end section without any page numbers).

- In the footer of the second and third remove "same as Previous" (it might be labeled differently in 2007—that’s how it shows up in 2003);

- Once that's done, you can mess around with the pagination in each section however you see fit.

Justin Reed said:I can't even open a file with him anymore—it’s just totally empty... seriously?

It happens—quite frequently, actually. Just an empty shell. Honestly, I'd say just give up on it.