|
|
| code logs -> 2024 -> Wed, 27 Nov 2024 | < code.20241126.log - code.20241128.log > |
| --- Log opened Wed Nov 27 00:00:25 2024 |
| 00:20 | | Vornicus [Vorn@Nightstar-8k6f0b.res.spectrum.com] has quit [Connection closed] |
| 03:20 | | Degi [Degi@Nightstar-3dnj9g.pool.telefonica.de] has quit [Ping timeout: 121 seconds] |
| 03:24 | | Degi [Degi@Nightstar-u70utq.pool.telefonica.de] has joined #code |
| 08:24 | | gnolam [lenin@Nightstar-770drn.cust.bahnhof.se] has quit [Ping timeout: 121 seconds] |
| 09:11 | | Vornicus [Vorn@Nightstar-8k6f0b.res.spectrum.com] has joined #code |
| 09:11 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 09:37 | | gnolam [lenin@Nightstar-770drn.cust.bahnhof.se] has joined #code |
| 09:37 | | mode/#code [+o gnolam] by ChanServ |
| 11:06 | < abudhabi> | Is there some kind of forcible method to make Excel interpret something as a number? |
| 11:06 | < abudhabi> | I have imported a bunch of stuff via power query from CSV, and I've got a column of either blanks or decimals. |
| 11:06 | < abudhabi> | Interpreted AS TEXT, of course, because Excel is being extremely dumb about it. |
| 11:07 | < abudhabi> | What's worse, the blanks aren't, somehow, blanks. |
| 11:07 | < abudhabi> | ISBLANK() returns false on them. |
| 11:07 | < abudhabi> | If I edit the value and just hit enter, it interprets a given cell as a number. |
| 11:07 | < abudhabi> | But I have about 20000 cells. |
| 11:08 | < abudhabi> | Is there some automated way to do this? |
| 11:08 | < abudhabi> | When I select the column, Excel doesn't give me the "convert the number" context button to press, even. |
| 11:08 | < abudhabi> | I have had this problem before, and I somehow managed to get around it, but I can't remember what it was. |
| 12:19 | | Emmy [Emmy@Nightstar-qo29c7.fixed.kpn.net] has joined #code |
| 16:19 | < abudhabi> | Eventually managed it with search and replacing, which for some reason did identify empty cells correctly where isblank() did not. |
| 16:20 | < abudhabi> | Search+replace also make excel treat things as numbers. WTF. |
| 16:20 | < abudhabi> | s/".0"/"" -> and suddenly it's a number now. |
| 16:22 | <&[R]> | Excel is a good way to have mass data corruption, it's baffling how popular it is given that |
| 17:49 | | Lamb3 [Dawg@Nightstar-0buihq.pbiaas.com] has quit [[NS] Quit: updates] |
| 17:53 | | Lamb3 [Dawg@Nightstar-0buihq.pbiaas.com] has joined #code |
| 20:31 | | Kimo|autojoin [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has joined #code |
| 20:31 | | mode/#code [+o Kimo|autojoin] by ChanServ |
| 22:57 | | Kimo|autojoin [Kindamoody@Nightstar-qg5daj.tbcn.telia.com] has quit [Ping timeout: 121 seconds] |
| 23:05 | | himi [sjjf@Nightstar-o4k.pal.170.103.IP] has quit [The TLS connection was non-properly terminated.] |
| 23:20 | | himi [sjjf@Nightstar-o4k.pal.170.103.IP] has joined #code |
| 23:20 | | mode/#code [+o himi] by ChanServ |
| 23:58 | | Emmy [Emmy@Nightstar-qo29c7.fixed.kpn.net] has quit [Ping timeout: 121 seconds] |
| --- Log closed Thu Nov 28 00:00:26 2024 |
|
| code logs -> 2024 -> Wed, 27 Nov 2024 | < code.20241126.log - code.20241128.log > |
|
|