ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Where do I get the slash sign for Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/109270-where-do-i-get-slash-sign-excel.html)

René Cloutier

Where do I get the slash sign for Excel?
 
I am trying to date the worksheets on an Excel workbook and I can't seem to
find the slash to separate dd/mm/yy
The slash works fine when within a cell, but not on tabs.
It usually is at the left of the number row, but not on mine. When I hit the
key, nothing happens.
Any help is appreciated.

Thanks

Dave Peterson

Where do I get the slash sign for Excel?
 
There are certain characters that won't work in the worksheet name. The / is
one of them.

Maybe you could use dd.mm.yy (or yyyy.mm.dd or yyyy_mm_dd)

René Cloutier wrote:

I am trying to date the worksheets on an Excel workbook and I can't seem to
find the slash to separate dd/mm/yy
The slash works fine when within a cell, but not on tabs.
It usually is at the left of the number row, but not on mine. When I hit the
key, nothing happens.
Any help is appreciated.

Thanks


--

Dave Peterson

hmm

Where do I get the slash sign for Excel?
 
Slashes--as well as colons, backslashes, questions marks, asterisks, and
brackets--are not allowed in worksheet names. Use another symbol, like a
hyphen.

"René Cloutier" wrote:

I am trying to date the worksheets on an Excel workbook and I can't seem to
find the slash to separate dd/mm/yy
The slash works fine when within a cell, but not on tabs.
It usually is at the left of the number row, but not on mine. When I hit the
key, nothing happens.
Any help is appreciated.

Thanks



All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com