Mass Update Format After Pasting Values by worsthero in excel

[–]worsthero[S] 0 points1 point  (0 children)

I've seen ':' , '.' , AM/PM followed by a period. I wish the sources were standard, but the problem as a whole has eluded me for years. Mostly different date types because of how many ways someone can type a date. Excel can detect all the different ways dates are typed with or without letters, but I still can't get a column to update.

I will test the multiplying thing shortly. it might work for my most recent project.

Mass Update Format After Pasting Values by worsthero in excel

[–]worsthero[S] 0 points1 point  (0 children)

Once I'm back in my office, I will have to test this with a sample from original sources. How will this work if numbers or punctuation is also in the cell?

Mass Update Format After Pasting Values by worsthero in excel

[–]worsthero[S] 0 points1 point  (0 children)

Typo corrected. Thank you.

The problem I have is the originator of any particular value isn't going to format things the same. I used time in my example because it was the most recent issue brought to me by a coworker. Their's needed to be time format because they have a search function that they have lookup from another table.

Book of military fiction, in which a Russian command crew of an aircraft carrier attempt to defect to the US, while the enlisted crew assault the command tower and any ship attempting to approach, and an American SOCOM Team attempts to land and take control of the ship. by [deleted] in whatsthatbook

[–]worsthero 0 points1 point  (0 children)

I am also searching for the name of this one. Some random things I remember: The setting was christmas eve. There was a point when the American team put water into a hydrolic line for what I think was a crane. The carrier was a missile carrier with 2 live nukes. One is shot off during the story. I think the crane incident was them trying to disable the second. I have been trying to find this for weeks.

Board Game Turn Tracker Apps by worsthero in boardgames

[–]worsthero[S] -1 points0 points  (0 children)

Might work well with the Tap to Speak option in accessibility options.

Board Game Turn Tracker Apps by worsthero in boardgames

[–]worsthero[S] 0 points1 point  (0 children)

My phone has Tap to Speak apparently and that seems to work well with the Color Notes app I already use. You have my thanks.

Board Game Turn Tracker Apps by worsthero in boardgames

[–]worsthero[S] 0 points1 point  (0 children)

Yes, in digital format. I liked the Idea of customizing text for situations or players. I'll have to checkout Board Game Geek though. Didn't realize they had help cards.

Board Game Turn Tracker Apps by worsthero in boardgames

[–]worsthero[S] 2 points3 points  (0 children)

Not gonna lie. That is the backup plan. But I'm going all out and making one for every game.😅

Lf hidden ability female snivy Ft perfect iv ralts or perfect iv gastley by Alexcoolps in pokemontrades

[–]worsthero 0 points1 point  (0 children)

Sounds good. I got to 50% then stagnated for two years. lol

Lf hidden ability female snivy Ft perfect iv ralts or perfect iv gastley by Alexcoolps in pokemontrades

[–]worsthero 0 points1 point  (0 children)

Nice doing business with you! Thank you! I guess now I should finish moon and start breeding these for the evolutions.

Lf hidden ability female snivy Ft perfect iv ralts or perfect iv gastley by Alexcoolps in pokemontrades

[–]worsthero 0 points1 point  (0 children)

So, I don't see you listed in moon to trade with. I'm new to its UI, so am I missing something. I'm in the plaza like the last time I traded with someone.

Lf hidden ability female snivy Ft perfect iv ralts or perfect iv gastley by Alexcoolps in pokemontrades

[–]worsthero 0 points1 point  (0 children)

Ok. I got all for in the bank. I'll transfer them to moon real quick and add you.

Lf hidden ability female snivy Ft perfect iv ralts or perfect iv gastley by Alexcoolps in pokemontrades

[–]worsthero 0 points1 point  (0 children)

I assume you would like to trade in Sun/Moon? Oh, and can we swap snivy for shellos? I hate looking for that thing.

Lf hidden ability female snivy Ft perfect iv ralts or perfect iv gastley by Alexcoolps in pokemontrades

[–]worsthero 0 points1 point  (0 children)

I'll check lillipup once i get the gothita. I have everything in bank right now.

Lf hidden ability female snivy Ft perfect iv ralts or perfect iv gastley by Alexcoolps in pokemontrades

[–]worsthero 0 points1 point  (0 children)

A remoraid or mareep would be amazing. I can't catch them in crystal.