I’m opening an output file from a design software program using the GetOpenFilename Method. Several of the cells have data like 1/4.
Sometimes 1/4 means text “1/4”
Sometimes 1/4 means a fraction one-fourth.
In all cases Excel decides it means January 4th.
Even when I open it manually using Data > From Text and select Column Data Format = Text Excel still decides it means January 4th.
Is there any way to force Excel to leave it as 1/4?
Bookmarks