Or they could set the format of the column to text instead of keeping it as general and everything would just work.
If these "scientists" are having this problem then they haven't spent any time at all learning how to use the tool they rely on.
Can we trust anything these people produce if this is the level of competence they have with Excel?