Reputation
1,538
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 31
Impact
~105k people reached

Mar
9
comment MS Word 2007 - Insert shape but keep that tool selected
@user3725743 You're welcome. If this worked for you, please accept the answer by clicking the check mark on the left, so that other users know the question has been resolved.
Feb
7
comment Convert all music files to 192 bitrate mp3 except of those already ≤ 192 kbps
@Tetsujin Right, MediaMonkey has both options. I'll add a note to my answer.
Jan
7
comment Excel number format to convert number of month to name of month
This sums it up pretty well. I guess I'll have to use a helper formula in another cell. Thanks.
Jan
7
comment Excel number format to convert number of month to name of month
Thanks, but I would like to be able to do this via a number format directly applied to the cell (applied via Format Cells > Number > Custom).
Jan
7
comment Excel number format to convert number of month to name of month
No, mmm doesn't accomplish what I am trying to do because it interprets the cell value as a date serial number, and returns Jan for all numbers 1-12 (Serial number 1 corresponding to date 1/1/1900 and 2 to 1/2/1900, etc.)
Jan
7
comment Excel number format to convert number of month to name of month
Thanks for this, but it doesn't really answer my question. I already know how to use custom formatting. My question is what custom format can I use to accomplish this. None of the formats in the built-in list or the list in the link you posted can directly convert a month represented as 1-12 to Jan-Dec.
Jan
7
comment Excel number format to convert number of month to name of month
@EricF I have considered a hidden cell, and I will use one if I can't find another solution. I would much rather use a custom format, but I'm just not sure what it should be. That's what I'm asking in my question.
Jan
7
comment Excel number format to convert number of month to name of month
@EricF I see what you mean. The reason is because I have formulas which refer to this cell and expect a number 1-12, but I would still like it to display Jan-Dec. I have looked into custom formatting, but entering "mmmm" just results in "January" as I mentioned in the question. Do you have any ideas regarding a custom format that could accomplish this?
Jan
7
comment Excel number format to convert number of month to name of month
@EricF What additional information do you think needs to be provided? I think the question is simple enough.
Jan
5
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
Did it fix both the wireless button and the mute button?
Nov
20
comment Excel- SUM formula not working on IF formula converted data
You should at least include the IF formula in your question.
Nov
14
comment Program to format external drive to FAT16 in Windows 8.1
Final FAT16 was the first to allow a disk size greater than 32MB. You can try choosing "FAT" in the Windows Format dialog and you'll see that you are able to create a volume greater than 32MB, therefore, it must be FAT16.
Nov
10
comment How to easily locate photo opened in Windows 8.1 Photo App
@LievenKeersmaekers I agree. Windows 8 full screen apps sacrifice functionality in favor of simplicity.
Oct
21
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
Thanks for your help, this actually did fix the mute button light. By the way, did you get the fingerprint reader to work in Windows 8? I'd like to use the fingerprint reader to log into Windows but nothing seems to happen when I install the driver.
Oct
21
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
Thanks, I'll try this later today. Did your wireless light work as soon as you installed Windows 8? Or was it later, after you installed some drivers?
Oct
20
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
So is there a place where I can download and install these "HP supported apps"?
Oct
20
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
That first link said that my laptop hasn't been tested with Windows 8. But it looks like they sell it with Windows 8 preinstalled sometimes... Look at the top of this page: h71016.www7.hp.com/…
Aug
3
comment Strange Visual Artifacts, Windows 7
Why did you downgrade the drivers? Driver updates often contain fixes for issues like this. Have you tried installing the latest driver update?
Jul
25
comment Changing what browser Excel hyperlinks open in
Here's a screenshot of the Chrome settings on my PC. The "Default browser" setting is highlighted at the bottom: i.imgur.com/2UZtJgm.png
Jul
25
comment Changing what browser Excel hyperlinks open in
They will open in your computer's default browser. In chrome settings there is an option to make chrome the default browser.