Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Special Characters in Sheet Name

I want to name a sheet 1/1/08. I right-clicked on the sheet tab but it does
not accept the slash character. Is there some way to do this?
--
Ann S.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default Special Characters in Sheet Name

As you've found, the '/' character is not allowed in a sheet name (since it
is a valid path separator). You will have to use a different character, such
as '_'.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Ann S." wrote in message
...
I want to name a sheet 1/1/08. I right-clicked on the sheet tab but it
does
not accept the slash character. Is there some way to do this?
--
Ann S.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Special Characters in Sheet Name

Some characters are not allowed in a sheet name. There is no way to put the
characters into the sheet name. Select an alternate scheme, like "1-1-08",
"1.1.08", "1_1_08", etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ann S." wrote in message
...
I want to name a sheet 1/1/08. I right-clicked on the sheet tab but it
does
not accept the slash character. Is there some way to do this?
--
Ann S.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Special Characters sandyboy Excel Worksheet Functions 2 September 19th 07 04:02 PM
Special Characters aftamath Excel Discussion (Misc queries) 1 October 18th 05 11:02 PM
special characters (little box) YuChieh Excel Discussion (Misc queries) 9 June 14th 05 01:41 PM
special characters tjh Excel Worksheet Functions 3 May 13th 05 10:50 PM
Special characters Gilles Desjardins Excel Worksheet Functions 2 December 8th 04 04:17 AM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"