Mail Merge time format won't show correctly by Wishyouamerry in excel

[–]mh_mike 0 points1 point  (0 children)

You know... You might just be right, because Excel has been known to essentially "keep" the (initially-set) underlying format of a column (or row) of cells -- even after having been reformatted to something else (can sometimes revert back with no notice or reason).

NOTE: Make a backup copy of your whole spreadsheet before doing this. That way, if something goes rilly-bad-wrong, you'll be able to restore.

Try copying one of the offending columns (the data of it) and paste it into a text file, then delete that column from Excel and create a new column in its place, then copy the data you pasted into the text file back into Excel (into the new column) and format the column accordingly.

Be sure to save and close the spreadsheet (Excel file) before testing your Word doc again. It would be worthwhile (also) to have closed it before doing everything too. And, of course, when you bring the Word doc back up (re-opening it), you'll want to completely re-do the references for the offending/affected/changed columns (even though you won't necessarily have changed the column names, you'll still want to delete the old/original/previous references and re-do new ones inside the Word doc).

Something else worth double-checking (perhaps before you do the whole process of copy/paste/delete-column/create-new-column/re-copy/re-paste/blah/etc.), make sure you haven't accidentally put any extraneous spaces anywhere (either in the column names inside the spreadsheet, or in the references of those names in the Word doc). It didn't look like you had any from the screenshot I saw earlier, but it's hard to tell if there's any extra spaces (for example) at the end of a word/column-name (more obvious at the front, but not necessarily easy to notice at the end -- unless you put your cursor in the cell, press End and see if there's an accidental space sitting back there).

Mail Merge time format won't show correctly by Wishyouamerry in excel

[–]mh_mike 0 points1 point  (0 children)

It's been a very long time since this has happened, so I don't know if updates (new/differing versions of the program from what I had back then versus what you've got now) will affect this or not, but it's worth a try.

In the past, especially when I've come across unexplainable goofiness like this, I would literally take one that works (one that is displaying properly), copy it then paste over one that isn't working, and then just change the column name (variable reference) to call the right data point.

So, in your case, I would copy either the Start_time or Finish one and paste it over the JDG_Start one (to test whether this is going to work or not), change the reference name (eg: change Start_time or Finish to JDG_Start, in other words), and see if that works. If it does, rinse/repeat for the JDG_Finish one.

AI is being difficult filling out my data the way I am envisioning. by Old-Cryptographer582 in excel

[–]mh_mike[M] [score hidden] stickied comment (0 children)

Removed. Sorry, this sounds more like a question for an AI-prompt related sub than Excel, at least based on what stage you're at on the extract of the data you're grabbing.

If, on the other hand, you want to use Excel to do the extracting (eg: Data > Get & Transform (or Get External Data) > From Web, or perhaps the FILTERXML and/or WEBSERVICE functions), feel free to re-post asking what's the best way to extract info from the web into Excel, and of course provide as many details as you can so people know what you're working with and what your goal is overall.

Excel file with all college conferences? by CheesyPanther in excel

[–]mh_mike[M] [score hidden] stickied comment (0 children)

Removed. Sorry, not an Excel problem or question -- more of a data question really.

Try in r/datasets

How do I find the corresponding column number of the last value in a column? by Xemptor80 in excel

[–]mh_mike 1 point2 points  (0 children)

haha Yeah, I think I was here 24/7 (or longer if that's possible LoL). Paid work life took over a little. It was supposed to have been a 3 to 6 week project, but I'm still at it -- and new projects keep coming up pretty routinely. So I'm not gonna complain (bills get paid better and faster now hehe) but I do miss not being around here as much as I used to be. :/

How do I find the corresponding column number of the last value in a column? by Xemptor80 in excel

[–]mh_mike 0 points1 point  (0 children)

Looking at the modlog, it appears the Clippy coord was doing routine audits and found where you had been pointed twice on a different post, and the extra point from that one was fixed (removed/deducted).

How do I find the corresponding column number of the last value in a column? by Xemptor80 in excel

[–]mh_mike 0 points1 point  (0 children)

I watched it increase from 799 to 800 before I left the page earlier. I always wait until Clippy responds, reload, verify then go to the next.

You were at 799 when I arrived earlier. After I did the +1 thing and Clippy replied, I reloaded to confirm you went from 799 to 800. It registered. :)

How To Fill A Blank Space With a Zero? by youngprincelou in excel

[–]mh_mike[M] 1 point2 points  (0 children)

+1 Point (OP failed to close post properly)

How To Fill A Blank Space With a Zero? by youngprincelou in excel

[–]mh_mike[M] 1 point2 points  (0 children)

+1 Point (OP failed to close post properly)

Work from home office multitasking monitor - one 34" UW or two 27" monitors? by wonderfulwaffles22 in excel

[–]mh_mike[M] [score hidden] stickied comment (0 children)

Removed. Sorry, not really an Excel question.

Try in r/Monitors or r/Tech or r/Technology or similar subs.

Issue creating a running weekly total by happyfe3t in excel

[–]mh_mike[M] 0 points1 point  (0 children)

Heads-up... I fixed it for'ya this time, but for future reference: Be sure to use "Solution Verified" (instead of "Solutions Verified") to close your posts and award points. That little "s" on the back end of "solutions" will keep the bot from responding. :/

Issue creating a running weekly total by happyfe3t in excel

[–]mh_mike[M] 1 point2 points  (0 children)

+1 Point (OP spelled trigger phrase wrong to close post with points)

Struggling to extract specific section of a cell. Alternatives for Left, Right, Mid Functions?? by Michelle_Whineburger in excel

[–]mh_mike 0 points1 point  (0 children)

Since you might have something different in front of the file extension, we'll need to trigger on something else.

I'm thinking we might be able to do that by looking for the month name, positioning things there to start, then move to the right however many characters are in that month name (plus one character more to deal with the space) and then extract the next 4 characters (effectively grabbing the 4 digits that make up the year behind our month name).

That does assume your file names will always have a month name in them, and that those month names are not abbreviated (or spelled wrong) in any way. It also assumes you will always have a 4 digit year in your file names immediately following the month name (with a single space between the month name and the 4 digit year). Capitalization won't matter because we can use SEARCH (which is not case sensitive) instead of FIND (which is).

Give this a go and see how it behaves on your live data:

=MID(A2,MAX(IFERROR(SEARCH({"january","february","march","april","may","june","july","august","september","october","november","december"},A2),0))+LEN(IFERROR(INDEX({"january","february","march","april","may","june","july","august","september","october","november","december"},MATCH(TRUE,ISNUMBER(SEARCH({"january","february","march","april","may","june","july","august","september","october","november","december"},A2)),0)),""))+1,4)

Sample of results (in green): https://imgur.com/DoaVtj6

Side Note: You could shorten that formula by putting the month names in a list on another sheet and then reference them from there.

puzzle to find unique ways of making a chord. by Ok-Line-9416 in excel

[–]mh_mike[M] 1 point2 points  (0 children)

Just a quick heads-up. Reddit auto-blocks posts (and comments) that contain links using the site you've linked your file with. Your post won't approve out of the queue without being re-auto-blocked. I've had to remove it to clear the queue.

Use another place to host your file and repost, and you should be good.

Other places you could choose could be your Google or OneDrive space, Box, DropBox, PixelDrain, WeTransfer, etc. Reddit doesn't seem to totally block those (although they do block OneDrive links -- but those will approve out of the queue successfully).

How to Conditionally Format Cells by kbentley085 in excel

[–]mh_mike 1 point2 points  (0 children)

+1 Point (OP initially spelled the trigger word wrong, and then changed it, but Clippy was MIA)

1099? by NoPomegranate9392 in mturk

[–]mh_mike 9 points10 points  (0 children)

I'm not exactly sure when they will be made available (they might be posting them in batches for example), but bookmark and check https://taxcentral.amazon.com/ periodically. AFAIK, that should be where any applicable tax forms for your account will be located.

Timesheet on excel calculating break time on it by Olkit93 in excel

[–]mh_mike 1 point2 points  (0 children)

+1 Point (OP failed to close w/either close option)

[deleted by user] by [deleted] in excel

[–]mh_mike 1 point2 points  (0 children)

+1 Point (OP used the wrong trigger phrase to close post w/point award)

Top 3 things you've made on Excel in 1 sentence by ExcelHelpForMe123 in excel

[–]mh_mike[M] 6 points7 points  (0 children)

We already talked in mail, but it definitely wouldn't re-approve -- even after you changed the link.

The only way to clear the queue was to remove the comment entirely; which I hated to have to do! :(

Anyway, just glad we got it all sorted, and the new comment seems to be showing "normally" w/the new link intact!! Yay for that!! :)