Windows 10 changed date format on Excel

Windows 10 changed date format on ExcelHaving recently installed Windows 10 on my main PC I hadn’t had many problems.  Until I went to use some previously created Microsoft EXCEL documents. It was then I noticed that Windows 10 had completely changed the date format on Excel from English UK to American US date format.

So instead of showing dd/mm/yyyy it shows the US version mm/dd/yyyy on all of my Excel Documents.

Thankfully there is an easy solution – which is to install the “English (United Kingdom)” language pack.

It sounds crazy that we have to do that – but it saves having to alter the cells on all of our documents and its quick and easy to do.

Windows 10 changed date format on Excel

Don’t Panic

Its easy to change all of your documents back to UK date format on Excel

First go to Control Panel in Windows 10

Set the view to small icons so that you can see the folders

  • Click – Language
  • You will see English US highlighted
  • Click – English UK
  • Download and Install
  • Click – Yes
  • Go back to the Control Panel click MOVE UP on the UK version
    Windows 10 changed date format on Excel

Restart Excel and

Voila

You will also now notice that the time clock is back to 24hrs and beside the time – are the language preferences and you now have English UK

Your UK date formats are back!

See I told you there was no need to panic when Windows 10 changed date format on Excel !

Virgin Media Fastest Broadband: why are people reporting 3mbs download speeds?

I’m very confused, if its true that Virgin Media are the fastest broadband supplier, why are people reporting 3mbs download speeds?  I personally am getting this problem – I pay for 100mbs broadband and for a while now I’ve been getting from 3mbs – 70mb through out the day – and really only after about Midnight does it go back up to 100 consistently – of course which is great as that’s bedtime.

Virgin media fastest broadband, why are people reporting 3mbs download speeds

Virgin Media told me this is due to traffic, basically there are too many people using Virgin Media and they are having problems fixing it.   They also said its only in peak times but this isn’t true, its all day long that speeds are bad but it is guaranteed to get worse at around 7pm onwards.

This example of my speedtest is from 2pm – no not as bad as some that I get with 3mbs download and 200+ ping but bad enough.

Virgin media fastest broadband, why are people reporting 3mbs download speeds

2PM

Virgin Media say that, the problem is in my area, and work has to be done with a box (assume exchange) which can’t be completed until January 2016.  Of course, I have complained and they have offered me a small discount.   I’m not sure this is good enough – I pay for 100mbs download speed and I am not getting anywhere close to this for most of the day – almost all of the day.

The Power of Super Fast Virgin Broadband – as long as its not peak times, or you don’t actually use it much..

At first I asked Virgin Media if I was being throttled for over use – they told me they didn’t throttle downloads ……  however I looked at their website and in the small print it clearly says

virginspeeds

Download Speeds maybe be affected by Traffic Management Meaures from 10am to 3pm – and 4pm to 9pm

I tweeted this to ZR who had been very vocal with his/her tweets previously but then strangely there was no reply.

virgin speeds

 

Virgin media fastest broadband, why are people reporting 3mbs download speeds

I thought I would investigate and see how many other people are complaining on twitter and the virgin media forums about this – and guess what – IT IS NOT JUST MY AREA!  It is country wide.  And its been going on for months.  I am not the only person complaining about virgin media download speeds. Not the only person with 3MB download speeds from Virgin Media when they are paying for a lot more – some people are paying for 152mb!

An engineer once told me that – they can turn a certain person up – so then others from the same exchange suffer, so if you don’t complain then you will never know.  I’m not sure that is correct or not, but it didn’t sound very good.

Why hasn’t the media caught hold of this or Ofcom.. this can’t be legal.  Why are they still signing new people up when they can’t supply what the rest of us what we pay for?   Its clearly an infrastructure problem if its going to take that long to sort out and its a probably all over the country.

We’ve now been told that from the first of October virgin media will be doubling our speeds ……. they have said this will not fix the slow speed problem …. wow thats helpful then.

What are Twitter saying – Please note this is a VERY small selection of many people saying the same, thing. I am compiling a list.

I realise that some people get very slow speeds and manage perfectly but for my usage I need more – that’s why I pay for more……  You get what you pay for ?  Not with virgin media…

Question is – do I wait while they sort this out – which may or may not be in 3 months – being as it took them 6 months to fix the last problem only 6 months ago – which was new cabling and a new box (that is actually a very long story which started in 2012. Maybe I should tell you that one)   Or do I bite the bullet and switch to BT or SKY broadband or both – and pay for a slower speed than I do now but hopefully more reliable.

I am now waiting for a manager to get in-touch with me. I requested this two days ago – and apparently it could take two more days… I’m such an important customer, we all are, clearly.   It might be due to the fact that the whole of South West of England – lost their broadband and TV for something like 24 hours recently, maybe that’s the hold up.

What are your views ?  Are you getting bad speeds from Virgin?   Are BT and SKY just as bad?  Do you ever even test your speeds? – look here Speedtest.net

Are you a Twit for using TrueTwit

Do you use TrueTwit?  Are you a Twit for using TrueTwit?  If you use Twitter you will probably have heard of TrueTwit which calls itself a validation account. That must be harmless enough you think? All you want to do is protect yourself from unsavory followers.

As you know I usually like to support games and apps with a mention and to help you, my readers know whats out there, what is new and what is great to use or play.  I realise that anything that is created is someones hard work and that they think its great. TrueTwit clearly think they are great but there are many people being annoyed by how it works, maybe they might think about changing how they do things.

Are you a Twit for using TrueTwit

You might be thinking what is a Twit, is that a good thing? It could be that Twit may be just an English word – so I shall explain the definition of the word Twit

Full Definition of TWIT

:  a silly annoying person :  fool

What exactly is TrueTwit

True Twit says that it stops you wasting time with spammers on Twitter – it verifies people from robots – avoids twitter spam – saves you time managing your followers.

This is what sucks people in, people that are struggling with social media management and want an easy way out – but its not the way to go…. much better to hire a social media manager if you have no idea what you are doing.

What does TrueTwit do

It sends annoying DM’s called TrueTwit Validation to people that have taken the time to follow you – people that hope that you will follow back and that you can create a connection with.

truetwitWhat appears in users DMs (private messages on Twitter) is above. Receivers of this message can’t even DM  you back because you aren’t following them yet, that is frustrating in itself.

This appears like spam because people you follow are just sending DMs with links into our private message area.

Now your followers (new twitter users) think that the only way they will get a follow back is by filling in the verification – and they only way around having to complete the CAPTCHA is to sign up for it themselves, and so goes the circle, a circle that needs to be broken.

penguin-160362_1280

I personally hate auto DMs anyway – whatever the reason – and I don’t even open them anymore, as they are usually all asking you to sign up for this or that and to do something, they all want something, and this is the same, its a waste of time. However, sometimes to be nice, I will tweet the person Hi – I don’t use truetwit and if they reply all well and good – if not I assume they are completely auto and unfollow.

Maybe people do not realise but this action of sending an auto DM asking users to prove that they are real can lose you followers. First because it creates a first impression of you that you can’t be bothered to engage, and second it proves that you are the one automation.  Which looks really really bad for anyone in a marketing or social media position using this service.

Are you a Twit for using TrueTwit

TrueTwit claims it stops bots from connecting with you – well it doesn’t, bots or spammers could probably complete a CAPTCHA anyway.

If you want to carry on using the service but want to stop sending out DMs you have sign up for the paid version… but why?

It seems it is probably only people that are new to twitter that get sucked into using TrueTwit because just about everyone you speak to doesn’t like it – they don’t like the spam emails or the fact that the people using it aren’t connecting like a real person would, which is what Twitter is all about.

How to stop using TrueTwit

If you have signed up and you didn’t mean to or you want to stop sending out DMs its simple
 Go to
  • Settings
  • Apps
  • Find True Twit
  • Revoke Access
These images from the @StoptrueTwit twitter account: check them out.
Are you a Twit for using TrueTwit

>

What are Twitter users saying about TrueTwit
That is just a small selection of people, I think it just about says it all.

If you use TrueTwit and thinks it really helps you to grow you followers, stop spam and increase your engagement on twitter I would LOVE to hear from you – I’ve only been on the receiving end, and who knows, maybe I’m wrong – it has been known. 🙂

SumoRank – Analyze Facebook Pages to Improve your Own Engagement

upload_folder_facebookToday there was a new launch from BuzzSumo – SumoRankAnalyze Facebook Pages to Improve your Own Engagement.

Matthew from BuzzSumo said today that together with Buffer (One of our top five tools), BuzzSumo analyzed 500 million Facebook posts to discover key strategies so that you can improve your Facebook engagement by analyzing what performs best for others.  What a fantastic idea!

We looked at how you can increase engagement in our last post about PostPlanner, and were keen to test SumoRank out also.

SumoRank – Analyze Facebook Pages to Improve your Own Engagement

The great thing about SumoRank  is that you can put in any Facebook page to analyze how they are getting views and what their most popular day is, to see how you can be doing things better.  We decided to nip over to check on PostPlanners Facebook page.

SumoRank - Analyze Facebook Pages to Improve your Own Engagement

The information supplied on the first page is

  • Most Popular Post Type – Image
  • Category Sumo Rank – #170
  • Most Popular Day – Saturday
  • (this was interesting as that came up on a few pages we tested)
  • Most popular time 12pm UTC

SumoRank - Analyze your Facebook page for free

You are then given Graphs showing

  • Estimated Monthly Total Interactions
  • Average Engagement per Post Type
  • Average Engagement per Character Range
  • Post per 3rd Party Tool and Average Engagement
  • Day Posted and average Engagement
  • Time Posted and average Engagement
  • Estimated Monthly Average Interactions
  • Top Posts

Sumorank2

Then right at the bottom, there is a link to see what is Trending Now on Facebook- where you can view all – or various types of topics.

Then you can also view

  • Most Shared
  • Content Analysis
  • Domain Comparison
  • Top Authors
  • Influencers.

And then it even goes deeper, by filtering the infomation that you want to know by date, time, type of content, type of influencer and more. Its just amazing how much valuable information they have packed into this tool – we suggest you check it out – or even watch the free webinar with Buffer and Buzzsumo on Thursday at 4.30pm BST.