Type the formula =Value() and inside the parentheses, type a cell reference that contains text stored as numbers. In this example, it’s cell A2 . Press Enter.

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 ...

Learn how to import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet easily using this procedure.