Blog

How to trick Sheets into displaying a date format with line break trick

Trick the Google Sheets page into applying line breaks in dates by using the \n switch. This links your preferred date format in the page code to a date format you custom create in Google Sheets.

Go to Custom number format and start by adding a custom number format. It doesn’t matter which format, but it’s best to create your own and leave the existing formats as they are.
Do NOT [Apply] yet

Tip: set the format to mirror the format you want (without line breaks) so that it’s memorable.

Now let’s trick Sheets by having the browser override this format with one including line breaks:
Press [F12] to open the built-in developer tools of the browser. Go to the Console tab and paste the following code into the console:

Object.defineProperty($(“[label=’Custom number format’]”), “value”, {value: “DD/MM\nddd”})

Hit [Enter] and close [x] the developer tools panel.

Now you are back in the Custom format dialog, hit [Apply] and the coding set in developer tools will be applied when youvuse this format.

Full article here

Fiche and chips?

https://theconversation.com/neuralink-has-put-its-first-chip-in-a-human-brain-what-could-possibly-go-wrong-222497?utm_medium=email&utm_campaign=Science%20Wrap%2045&utm_content=Science%20Wrap%2045+CID_42b860703c30606bac5ad40bb74b36b8&utm_source=campaign_monitor&utm_term=Neuralink%20has%20put%20its%20first%20chip%20in%20a%20human%20brain%20What%20could%20possibly%20go%20wrong

Earlier this week, Elon Musk announced his brain-computer interface company, Neuralink, had implanted a device in a human for the first time. The company’s PRIME study, approved by the US Food and Drug Administration last year, is testing a brain implant for “people with paralysis to control external devices with their thoughts”.

We’ve moved back into web design and have added creative media to boot. Plus…

You can help promote a sister site..

So,

Belated greetings for the New Year / Year of the Dragon, and hope that you and yours are doing well.

I’ve made my first foray into THETUBE:
https://youtube.com/@mindfulmotorcycling?feature=shared

and have rebranded my web/blog
ridersanddrivers.wordpress.com/vids/motorcycle/

Hopefull it will be of use..

Spread it ’round if you can. I’d like to get some traction on the YouTube channel and Rider and Driver Development. Hoping to get itinerant work whilst Mari and I go walkabout next year.

Speed up your Sheet by making Conditional Formatting permanent

Conditional formatting slows a sheet.

Here’s how tp remove those rules from a dataset that no longer need to be conditional.

  • Highlight the dataset
  • Copy your dataset (Ctrl + C)
  • Clear formatting (Ctrl + \)
    • Sheets: Go to menu: Format > Clear formatting
    • Excel: Home menu (Edit group): Clear > Clear Format
  • Right-click within your dataset
  • Select: Paste special (Ctrl + Alt + V)
    • Sheets: > Format only
    • Excel: use the formatting icon, or > Format

Now the formatting is permanent; conditional formatting rules have been removed and the sheet is faster.