Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch

F'Laps - Saturday 5th July

Join in with our challenge this Saturday. Run a set distance every hour until you can't run any more!
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 102 watchers
Mar 2019
1:27pm, 22 Mar 2019
18,166 posts
  • Quote
  • Pin
flanker
So all those hours spent writing import scripts or text editor macros to sort out dodgy output could have been avoided? :'-(
Mar 2019
3:41pm, 22 Mar 2019
3,372 posts
  • Quote
  • Pin
run free
Been there since Excel 5!!! Also Power Query can also do the same trick plus more
um
Mar 2019
12:02am, 23 Mar 2019
830 posts
  • Quote
  • Pin
um
Be careful with dates though ... I found it often auto assumed US dates (although most of my colleagues were US) except when the day of the month was >12 and it then mixed in UK format (ie 3/5/19 would be 5th March while 13/5/19 would happily be 13th May in the same column)
(I know there is a date format specification, but that takes an extra step!)

Any other things that you don't know about?
Mar 2019
9:13am, 23 Mar 2019
3,868 posts
  • Quote
  • Pin
Curly45
Haha dates piss me off in excel. I tend to convert everything to the numeric code and work with those then use a helper cell with the code formatted as date for everyone else to use. Date sorting is a pain in bum otherwise!
Mar 2019
12:45pm, 23 Mar 2019
8,944 posts
  • Quote
  • Pin
NDWDave
Remove duplicates is also quite handy
SPR
Mar 2019
12:49pm, 23 Mar 2019
27,600 posts
  • Quote
  • Pin
SPR
Never had issues with Excel and dates.

Access on the other hand...
Mar 2019
1:00pm, 23 Mar 2019
8,946 posts
  • Quote
  • Pin
NDWDave
Don’t get me started on dates. I worked for a British company which was bought by an American one and then by a French one
Mar 2019
1:26pm, 23 Mar 2019
41,511 posts
  • Quote
  • Pin
GlennR
Our septic cousins have got it more right than we have though. MMDD goes in correct numerical order, and if the international standard was YYYYMMDD things would be a lot more logical than they are now. Some firms I’ve worked for used that for dating documents.
Mar 2019
1:45pm, 23 Mar 2019
8,947 posts
  • Quote
  • Pin
NDWDave
I use yymmdd too when naming files. It was more the flip flopping of formats.

I had someone who set up a folder structure 1st Q 2017, 2nd Q 2017. When sorted, they were the wrong order
Mar 2019
2:24pm, 23 Mar 2019
35,312 posts
  • Quote
  • Pin
Diogenes
MMDD is only in the correct numerical order if you have YYYY at the front. It’s batshit to have MMDDYYYY

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work

Report This Content

You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.



Thank you for your report. The content will be assessed as soon as possible.










Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,478 Fetchies!
Already a Fetchie? Sign in here