ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   excel all cells begin with hyphen now (https://www.excelbanter.com/new-users-excel/176446-excel-all-cells-begin-hyphen-now.html)

clickerfixer

excel all cells begin with hyphen now
 
I some how set all the cells in my excel workbooks to put a hyphen before
text I type in - This is now afecting my hyper links - I dont remember how I
did it and cant turn it off. Can someone help????

JP[_4_]

excel all cells begin with hyphen now
 
I can duplicate your problem if I set the cell format to:

"-" @

Then Excel places a hyphen at the start of every cell after I enter
some information. You might want to check the worksheet formatting,
especially if you have a default workbook (book.xlt).

HTH,
JP

On Feb 12, 12:06*pm, clickerfixer
wrote:
I some how set all the cells in my excel workbooks to put a hyphen before
text I type in - This is now afecting my hyper links - I dont remember how I
did it and cant turn it off. Can someone help????




All times are GMT +1. The time now is 07:03 AM.

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