kingdragonfly:richms:
Finding that someone has entered product codes into an excel sheet with a backslash instead of a forwardslash and their reason was that it was dividing the numbers if they used a forwardslash. FFS these people end up employed.
I'm guessing you know, if you format the column cell category as "text" instead of the default "general", Excel will treat any text in cell as text.
The "annoy" was about other people from the way I read it.
But I immediately went to Excel to test it. You can enter "365/256" (without quotes) and it will treat it as text. In order to divide, you need to type "=365/256" for it to become a formula.
The only proviso might be that if you enter a valid date "25/6" then it might auto interpret that as a date and format accordingly. But generally even those will default to whatever you type unless you have an overriding date format default somehow.
So, from what I could gather, the "someone" would have needed to go to some effort to get it to divide the product codes instead of just displaying the text. (Unless later versions of Excel changed this behaviour, I'm still using Excel 2010).