Entering a hyphen

[kirkm]

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

 

[Ron Rosenfeld]

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

 

[kirkm]

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

Beauty! Thank you, Ron