Punctuation in file names

Farback

Board Regular
Joined
Mar 27, 2009
Messages
149
In our office we use Microsoft XP Professional, running Excel 2002 and Windows 2002.
I am trying to establish some 'standards' for staff to adhere to when creating files and folders. One thing I have emphasised is that Full Stops (periods) should not be used in file names, except immediately before the file extension (.xls, .doc etc.). But I have one staff member who repeatedly uses Full Stops in dates i.e. '02.02.12 meeting.doc'
She tells me she has "never seen it in writing" that this should not be done.
Can anyone give me some definitive advice on this, to strengthen my argument?
Is it acceptable practice, and if not (as I suspect) then why not?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
A full stop is not actually illegal.

http://msdn.microsoft.com/en-us/library/windows/desktop/aa365247(v=vs.85).aspx


It is possible that it *may* cause confusion in certain circumstances but, other than that, no reason why not. I can't quote examples off the top of my head so that leads me to think it may have been something I had a problem with in the past but not seen recently ... but then I don't tend to use full stops in file names (probably because I've had problems in the past).
 
Upvote 0
A lot of times you'll see full stops get stripped from files when they're e-mailed, whereas underscores won't be.

HTH,
 
Upvote 0
Stripping characters from filenames of attached files? Which mail clients? Or is that done by sending or receiving servers? From my own experience, Lotus Notes client and server, AOL and Gmail don't do this.

Aside from e-mail, neither Windows nor Excel should have any problem with arbitrary numbers of periods in filenames. The only technically legal filename (one Windows can handle) which Excel can't handle is .xls . Excel can handle all the filenames ..xls, ...xls, ....xls, etc. These may be quite unwise, but using . as a separator between days, months and years in formatted dates doesn't seem unreasonable.

Is the problem server/admin software which simplistically sets filename extensions as text following the first rather than last . in filenames?
 
Upvote 0
If someone sends me an Excel workbook like this:

Test v.1.1.xls

It'll often open on my end like this:

Test v11.xls

Or

Test v 1 1 .xls

(In Outlook 2010)
 
Upvote 0

Forum statistics

Threads
1,225,611
Messages
6,185,996
Members
453,334
Latest member
Prakash Jha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top