Discussion Locked

saving an .xls to a .dat in Excell 97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm in Excell 97 and I'm doing a save as to save the file as with a .dat extension and the .dat extension doesn't show up in the save as box. How can I get it to save as a .dat file from an .xls ?

I would appreciate any help on this.

Thanks inadvance.

5 replies

by chainsawz

Save the .xls file as a tab delimited text file, and then open it up in a program like notepad. In notepad, select file - save as, and change the file type to all files. Then, in the file name window, type the name you want to call the document and add a .dat extension. This should do the trick.

by dklippert

Go to Save as. Choose the layout you want, Tab or Comma delimited.
Enter the file name "Book.DAT" WITH quotes around the name and extension.

This discussion is closed to new replies.