this post was submitted on 24 Oct 2023
212 points (95.3% liked)

Technology

59374 readers
3714 users here now

This is a most excellent place for technology news and articles.

Our Rules

  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots

founded 1 year ago
MODERATORS
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
212
Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes (gizmodo.com)
submitted 1 year ago by [email protected] to c/[email protected]
24 comments fedilink hide all child comments
 

Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes::Microsoft now allows users to disable automatic date conversion, which means scientists no longer have to worry about using alternative names for genes.

you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 25 points 1 year ago (3 children)

I thought setting a column to string only was already possible.

[โ€“] [email protected] 18 points 1 year ago

You could already, after the fact, and per cell.

If you're importing 100,000 rows in, the damage to your data is already done by the time you're at the step where you can set the field to not convert.

load more comments (2 replies)