Re: Removing filing extension from header

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dave:
No argument from me (I hate not seeing extensions), but I figured that if
the OP *used* to see just the filename with no extension, then they are used
to working with this setting checked.

(Still not sure how/if only upgrading Excel changed this Windows setting,
but...)
--
George Nicholson

Remove 'Junk' from return address.



"Dave Peterson" <ec35720@xxxxxxxxxxxxxxxxx> wrote in message
news:429E26DC.C4EDCDCB@xxxxxxxxxxxxxxxxxxxx
> George told you how you could change this setting, but I wouldn't do it.
>
> Lots of viruses (virii) or other malicious junk can masquerade as
> text/picture
> files if you hide the real extension.
>
> Picturesfromourvacation.jpg
> could really be
> picturesfromourvacation.jpg.exe
>
> Clicking on that executable could be bad.
>
>
>
>
> fixcpa wrote:
>>
>> I prepare financial statements that contain between 10 and 30
>> worksheets. I would name the file "March 31, 2005" and use the file
>> name function in the header to have "March 31, 2005" appear on each
>> worksheet. When I used Excel 2000, the header would read "March 31,
>> 2005". After I upgraded to Excel 2003, the header now reads "March 31,
>> 2005.xls".
>>
>> Is there any way to remove the .xls extension from the header. I would
>> hate to have to manually enter a date on each worksheet.
>>
>> Thanks,
>>
>> Marc
>>
>> --
>> fixcpa
>> ------------------------------------------------------------------------
>> fixcpa's Profile:
>> http://www.excelforum.com/member.php?action=getinfo&userid=18235
>> View this thread:
>> http://www.excelforum.com/showthread.php?threadid=375640
>
> --
>
> Dave Peterson


.

Relevant Pages

  • Re: more OT: search-and-replace commands (was Re: OT: Why is C so popular?)
    ... > As much as I hate to admit that MS can do some things right, ... files and only change the extension. ... well as various DEC OSs (which were the inspiration for CP/M). ...
    (Debian-User)
  • Re: how to spoof the browser type
    ... On Wed, 2005-01-05 at 10:05, Tarjei Knapstad wrote: ... >> I've been using the extension since it was released, it works fine, but ... >> I hate that websites. ... It works the way the Wang did, ...
    (Fedora)
  • File Associations, Stupid Question...
    ... I'm hate to ask this, and I should know the answer. ... computers long enough, ... I inadvertantly associated a temporary file extension with an ...
    (microsoft.public.win2000.general)
  • Re: Finding file names
    ... Excel seems to find the file I've created, ... and the extension effects the final outcome. ... >> Dave, ... >> Dave Peterson ...
    (microsoft.public.excel.programming)