MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help with filename types in "Save As":


Posted by Tim Barber on October 03, 2001 7:35 AM

First, thanks for this service, it's much appreciated. Now my question: I am entering several hundred spreadsheets that I need to be able to sort in Windows Explorer by either the filename or the extension (file type). I want to use a filename format like "882900201.1590". However, Excel "Save As" only lets me save it with an .xls or other standard extension, giving me "882900201.1590.xls". I don't want to have to go back and edit all 500 filenames to get rid of the ".xls". Is there a way to Save As without adding the .xls extension to the filename?


Posted by Barrie Davidson on October 03, 2001 8:18 AM

Why not leave the ".xls" extension? You'll still be able to sort by filename or filetype and the file will still be recognized as an Excel file by Windows.

BarrieBarrie Davidson

Posted by Juan Pablo on October 03, 2001 8:20 AM

I don't know why you need this because it WON'T be available to Excel, put a couple of double quotes when you are saving it, like this:

"882900201.1590"

Instead of just

882900201.1590

Juan Pablo