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 |
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 |
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