Entering a hyphen
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 |
Entering a hyphen
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 |
Entering a hyphen
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 |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com