UK-CENSUS-HELPERS-L Archives

Archiver > UK-CENSUS-HELPERS > 2004-10 > 1098211131


From: "Irene Marlborough" <>
Subject: Re: [UK-CENSUS] hyphen question
Date: Tue, 19 Oct 2004 13:38:51 -0500
References: <20041018203928.VWMQ7401.priv-edtnes46.telusplanet.net@davelob34nic0c> <00cd01c4b565$ada347e0$b3d4a4cb@xpoemx23wbrh7m> <000d01c4b59c$94b08ae0$0600000a@CHERYL> <000301c4b5f5$2c3d0cf0$b890bf42@coleenc>


Hi there:
Another way around this problem is to tell Excel that you are typing text
only.

1) Select all rows and columns by clicking on the beige box (cell) above
the 1 of row 1.
2) Then from the menu go to Format, Cells.
3) Select the Number tab and pick Text from the category box.
4) Hit OK and you are done.

If you do this to your sample spreadsheet - you know, the one you use to
start every piece - then it only has to be done once and it's fixed forever.
Excel no longer thinks you are trying to type a formula or anything.

I hope this helps,

Irene



This thread: