Hi, this must be a pretty basic question, please excuse
my lack of knowledge.

I right click a cell in Excel, select Format - Text.

Next double click the cell and enter a hyphen.

Excel adds stuff like "F28" after it.

Can I stop Excel doing that and have the cell accept any
character I want ?

Thanks - Kirk

On Sun, 24 Sep 2006 14:07:05 +1200, kirkm
wrote:

Hi, this must be a pretty basic question, please excuse
my lack of knowledge.

I right click a cell in Excel, select Format - Text.

Next double click the cell and enter a hyphen.

Excel adds stuff like "F28" after it.

Can I stop Excel doing that and have the cell accept any
character I want ?

Thanks - Kirk

After you enter the hyphen, hit <enter instead of navigating away with another
click.


--ron

On Sat, 23 Sep 2006 22:59:04 -0400, Ron Rosenfeld
wrote:

Beauty! Thank you, Ron


After you enter the hyphen, hit <enter instead of navigating away with another
click.


--ron