Navigate to the "Number" group within the "Home" tab in Excel. Click the small arrow beside the "Number Format" box. Click "Text" to convert your cells to text formatting.

How to Convert DAT to Text in Excel. DAT files are files with an extension that isn't associated with a specific application or program and can be almost any type of file including video, media or ...

Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even sentence case with minimal effort.