I've run into a problem in Excel that seems to be a Microsoft "issue," and I am looking for a workaround if anyone has any ideas.
I have an Excel file that is used as a form for multiple users. One cell is for text where users are writing instructions and often have to include part names, including hyphens. For example:
"Contractor to provide all labor and materials to provide additional paper towel dispensers (model Bobrick B-318) and change the soap dispensers to the Elite soap dispenser...blah blah blah"
Excel automatically cuts off all text after the hyphen. In other words, "Contractor to provide all labor and materials to provide additional paper towel dispensers (model Bobrick B" is all that appears in the cell. I have tried adding apostrophes before the "B-318", and before the hyphen itself to no avail.
Does anyone have any suggestions for formatting this form to allow the multiple users to use it and enter hyphens?
I appreciate your help.
Kathleen
Bookmarks