Posted on 09/17/2017 5:04:32 PM PDT by dayglored
It contains the following in a single column. I selected the column and set the formatting for the column to be date with "03/14/12".
| date |
| 1/20/1882 |
| 2/15/2015 |
| 1/21/1792 |
Then I did a sort. Here's what it displayed.
| date |
| 02/15/15 |
| 1/20/1882 |
| 1/21/1792 |
You'll notice it only zero-padded 1 entry. It also completely failed to sort. Astounding that Excel still can't handle this elementary operation. Looks like the version is Office 2013.
Re: Bill Gates, thank God.
But when they finally get some good leadership (Satya), no one notices or cares.
I am a charter member of the "Microsoft Sucks Worse Than the Vacuum of Space" choir. That said, I think the recent moves by Satya are good. I also feel like they are mostly inevitable. In the enterprise, the only compelling offering is Exchange, primarily because of mountains of inertia and a general dearth of knowledge about alternatives. Microsoft is in some serious trouble because MS-Windows scales for shit.
Of course, the fact that Satya is better than Ballmer is a pretty low bar. He definitely seems to be able to consider alternatives that Ballmer was incapable of. This is good. On the other hand, the ham-handed Windows 10 forced upgrade regime was completely on Satya's watch.
I'm cautiously optimistic that having greater support for Linux is a good thing, as long as Microsoft can keep from executing their standard EEE approach, which would be difficult to execute in this case anyway.
One thing I've found to be really funny to watch over the past few years is seeing die-hard MS-Windows partisans extolling the virtues of Powershell, after making disparaging comments about command line tools like Bash for literally decades. I still shudder every time I have to deal with Microsoft software in any meaningful way, because it is always so clunky to me. The lack of virtual desktops in their default GUI shell still amazes me.
Yes
Excel stores DATE as a long integer. 1 (or maybe 0) is 1900 and earlier dates are negative numbers. Libre Office Calc handles negative numbers as earlier dates, no problem.
This is a problem if you plan to send someone a sortable spreadsheet for genealogical research.
Thanks for indulging me on this experiment.
Spits (coffee...)
Dude, seriously? Their on-premises burden of a messaging server???
That's the first thing I gave up when Cloud Services started. Went Exchange Online and never looked back.
Without Internet connectivity, messaging servers are, well, useless?
So why run it locally? Get it all from the Web.
I say this as a MCSE, Messaging, since Windows NT. I have certified on Exchange 5.0 all the way to 2013. We had 25K+ accounts. I gave it all up for Exchange Online. AND, I no longer get calls at O'Dark 30 to come in and fix email.
And before I go, I love Windows Server 2016. I even use it as my desktop.
I was speaking generally. Personally, I think exchange is a cluster. I hate having to deal with it. However, Microsoft has convince a lot of its die-hard drones that it is the only messaging platform for large corps.
Where I work, I was just converted to O365, which is an even worse mistake IMO.
So why run it locally? Get it all from the Web.
Because if you don't control your data, you don't control your data.
If your data is in the 'cloud', you have given up control of your data. For many companies, this data is a very real asset. I do not think it's necessarily a good idea to give that away, especially if there are privacy implications.
It’s SMTP. You actually DON’T control the data.
You know, mail sent from others. Without the Internet (and Cloud is just a fancy term for storing something on the Internet), SMTP is pretty worthless.
As I tell people, you lost “control” when you first plugged into it. Not the cloud, but rather the Internet.
“but to help shape the future of Linux”
Yes, add the swiss cheese. (Holes in security) Sucks.
Here is a list of Linux Compatible sound cards.
Genuine Sound Blaster (non-win modem) cards were original the fool proof method. Some other cards work too. Hardware cards, not software cards.
Some distributions of Linux work with some soft cards too.
“That’s right kids, I do Linux now...”
Not on one of my Linux boxes. I always despised that Smart A paper clip.
Sorry wrote the message and did not add the link
Here is the list of compatible sound cards.
http://www.tldp.org/HOWTO/Sound-HOWTO/x96.html
External real modems can be your fiend.
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.