3,048 reputation
513
bio website Blogger-hints-and-tips.blogsp…
location Ireland
age
visits member for 4 years, 1 month
seen 12 hours ago

1d
comment How to mix numbers formula in text format to formula format?
Alternatively, change A1 to =8/39 etc (so it displays as a decimal value), and then the simple approach will work, provided you divide it by 39 too. Fundamentally, though, this looks like a design problem: you should probably have the two parts of each cell (eg the 8 and the 39 in cell A1) in two different cells, and then do the maths you want on them in another cell.
1d
comment Google Sheets Suffix To Column Cells
Why do you need to use the PowerTools add-on? Won't ordinary copy-and-paste do the job?
Aug
21
comment When does the next year become available as a start date in LinkedIn?
I'm pretty sure that LinkedIn is for recording what you HAVE done, not what you PLAN to do.
Aug
20
comment Why is Google hiding the search input field?
Happens to me that way too: work is Win 7. Home is Win 8.1
Aug
20
comment Is there any way to set localisation settings in Google Now?
"Since the only country in the world that calls football "soccer" is America" Ahh, I'm not sure that's true. In ireland "football" means gaelic-football, while the other round-ball sport is called "soccer". In New Zealand, football is short for rugby-football, and scooer is, well, soccer!
Aug
20
comment Is there any way to set localisation settings in Google Now?
"Since the only country in the world that calls football "soccer" is America" ahh, I'm not sure that's true!
Aug
15
comment Why is the “Confirm access to my recovery email” option disabled?
Are you sure that you have set a recovery address for this account?
Aug
14
comment Google Spreadsheet changing cell references on its own
Indeed. I spent some time looking for a solution with array formulae, but they also seems to push the subsequent content down.
Aug
12
comment How to archive all the posts from a Facebook Page?
Please define what you mean by "archive". Delete? Take off-line to most people can't see them but you have a copy somewhere else?
Aug
7
comment How to handle Negative Time Delta in Google Spreadsheets
I was working on it as you typed! See below.
Aug
7
comment How to handle Negative Time Delta in Google Spreadsheets
That will only work in cases when the later time is in the morning and the earlier one is in the afternoon.
Jul
30
comment Easy way to mention my own blog link?
fyi, I decided to investigate the issues behind this question in more depth. The answer above does not change. What I found, and some other relevant info, is here: blogger-hints-and-tips.blogspot.co.uk/2014/07/…
Jul
30
comment How to make Google speak British English?
Which particular British accent did you have in mind - Cockney? Geordie? Scouse?
Jul
28
comment I made an error and need to change a primary gmail address
What product is this in?
Jul
24
comment How to contour data from a Google Spreadsheet?
Why is using a GIS not allowed? Is this a school assignment that you're asking us to help you with?
Jul
22
comment How can I make Google Sheets tell me how many of each date are in a column?
Just put it in as many rows as you might realistically every have.
Jul
22
comment How can I make Google Sheets tell me how many of each date are in a column?
You need to put the formula in as many rows as you think may realistically by used. Up to 65,536 if you expect that much data - but if you do, you really should be building a solution in a robust database that's scaled for the problem at hand, not using a spreadsheet!
Jul
22
comment Someone's Google account under my domain, how to ask for removal?
If someone wants to lie to other people and mailing list, and say that their email address is theirName@yourDomain.com then there is nothing you can do in the on-line world to stop them. Maybe you could get a court order for harassment (or something) - but only if you can track down who the person is in real life. Good luck with that.
Jul
9
comment Freeze first row of Google spreadsheet when displayed in Google site
How exactly have you displayed the Sheets file in your Site?
Jul
7
comment primary gmail address
You need to tell us more about how "Google made me create a new email address".