Show Posts

This section allows you to view all posts made by this member.


Messages - etech0

Pages: [1] 2 3 4 5 6 7 ... 984
1
Just Shmooze / Re: Jewish Music (New CDs, hock, and opinions)
« on: May 18, 2018, 12:36:02 AM »
is there anywhere to download a zip of all the free singles on mostlymusic?

2
Just Shmooze / Re: Random questions.
« on: May 16, 2018, 07:04:49 PM »
for a while. too many disputes??
I haven't ever disputed with this card and I have it for a few years

3
Just Shmooze / Re: Yanny or Laurel
« on: May 16, 2018, 09:10:11 AM »
Laurel on laptop, Yanny on desktop

4
Just Shmooze / Re: Random questions.
« on: May 15, 2018, 11:23:34 PM »
Does anyone else find that they can't use amex on aliexpress? Every time I try, they send me a SafeCode via email, and when I enter the code it tells me that the payment failed.

5
Just Shmooze / Re: Yanny or Laurel
« on: May 15, 2018, 09:51:16 PM »
I pronounce it "data", not "data"

6
Tech Talk / Re: Excel Help and Problems
« on: May 15, 2018, 11:01:24 AM »

7
Tech Talk / Re: Excel Help and Problems
« on: May 15, 2018, 10:59:53 AM »
It says invalid format as soon as I add the s.
Ah, I see. Try putting the s in quotes

8
Tech Talk / Re: Excel Help and Problems
« on: May 15, 2018, 10:45:57 AM »
Correct.

Awesome, thanks!

Worked great for 5000+ (I don't need decimals here), but isn't working for 100s. I suppose I could instead use 100+, 200+, etc. if needed.
Funny that it's not working for the 100, 200... it works for me. What's it showing you?

9
Tech Talk / Re: Excel Help and Problems
« on: May 15, 2018, 10:14:07 AM »
You can do it in google sheets by applying a number format. Select the cell(s) you want, click Format > Number > More Formats > Custom Number Format. Enter this for the format:

Code: [Select]
#,#+
(won't work if you have decimals, we'll have to tweak it then)

10
Tech Talk / Re: Excel Help and Problems
« on: May 15, 2018, 10:07:37 AM »
Not all, only a few. Few enough that this process won't be that much of a pain.
So how does Excel know which ones to add it to? Are you only applying the conditional formatting to those cells?

11
Tech Talk / Re: Excel Help and Problems
« on: May 15, 2018, 10:03:44 AM »
Found the solution here:

https://www.extendoffice.com/documents/excel/4264-excel-display-different-text-than-value.html

Basically I'm inputting 5000 but the cell is displaying 5000+. Slightly convoluted, but it works.

Now let's see if I can get it to work in Google Docs as well :P.
So you want them all to display a + after the number?

12
Tech Talk / Re: Excel Help and Problems
« on: May 15, 2018, 09:07:25 AM »
Is there a way to sort numbers correctly if the field isn't just numbers? For instance, I want the following to be sorted largest to smallest:

100s
5000+
34

Bonus points if they can still be used in calculations - I'm mainly looking to total them. Of course it won't be exact, but 5164 would be acceptable.
You can probably use regexextract to extract just the numerical digits, in a formula in a separate column. Then sort by and total the second column.

You can do regexextract in google sheets or with an excel addon

13
Tech Talk / Re: Group texts
« on: May 13, 2018, 07:41:36 PM »
I haven't used it, but someone recommended twilio somewhere on ddf

15
Tech Talk / Re: Group texts
« on: May 13, 2018, 03:37:12 PM »

Pages: [1] 2 3 4 5 6 7 ... 984