excel all cells begin with hyphen now

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

clickerfixer - 12 Feb 2008 17:06 GMT

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

Reply to this Message

JP - 12 Feb 2008 18:49 GMT

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
<clickerfi...@discussions.microsoft.com> 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????

Reply to this Message