excel - Laur's blog

Sign in Subscribe

excel

A collection of 3 posts

Change Decimal Comma to Dot in Excel Mac

Change Decimal Comma to Dot in Excel Mac

TL;DR: There are two things you can do: 1. Change in Language & Region -> Advanced... 2. When converting a text to columns, you can specify the delimiter (Step 3 of 3 -> Advanced...) Regional settings The regional settings will affect all applications, not only Excel. Here

Punchcard-ish Graph from Google Analytics Data

Punchcard-ish Graph from Google Analytics Data

The other day I wanted to see when users are actually using my website. The most obvious way (to me) is to have a github-like punchcard graph. My alternatives were to either write a program or use Excel. To cut a long story short, I chose to use Excel. If