I'm a new Excel user, using XP office excel. Well, I am trying to enter
some text in the cells. Andormeda Galaxy is of type G - Sb. When I
enter G- Sb, excel thinks it is some formula. The same thing with the
coordinates like latitude and longitude numbers. How can I enter the
data AS IS: and NOT AS A FORMULA.

Thanks

Shanks

Type a single quote (apostrophe) before you type the test
OR
Format the cells for Text before typing
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
I'm a new Excel user, using XP office excel. Well, I am trying to enter
some text in the cells. Andormeda Galaxy is of type G - Sb. When I
enter G- Sb, excel thinks it is some formula. The same thing with the
coordinates like latitude and longitude numbers. How can I enter the
data AS IS: and NOT AS A FORMULA.

Thanks

Shanks

You have two options.

1. Put a ' in front of your text, to force Excel to accept it as text.
Example: 'G- Sb
(don't worry, the ' won't show in the cell... only the formula bar)

2. Turn it into a formula. Example: ="G-Sb"

Which you use will depend on your situation.

" wrote:

I'm a new Excel user, using XP office excel. Well, I am trying to enter
some text in the cells. Andormeda Galaxy is of type G - Sb. When I
enter G- Sb, excel thinks it is some formula. The same thing with the
coordinates like latitude and longitude numbers. How can I enter the
data AS IS: and NOT AS A FORMULA.

Thanks

Shanks

Either format the cells as text before you begin (right click the range you
want to enter the data in Format Cells Number Select 'Text1') or
precede each entry with an apostrophe ('). It will show in the formula bar
but not in the cell,
Regards,
Alan.
wrote in message
oups.com...
I'm a new Excel user, using XP office excel. Well, I am trying to enter
some text in the cells. Andormeda Galaxy is of type G - Sb. When I
enter G- Sb, excel thinks it is some formula. The same thing with the
coordinates like latitude and longitude numbers. How can I enter the
data AS IS: and NOT AS A FORMULA.

Thanks

Shanks

'Text1'
Idiot (me)
'Text'
Alan.
"Alan" wrote in message
...
Either format the cells as text before you begin (right click the range
you want to enter the data in Format Cells Number Select 'Text1') or
precede each entry with an apostrophe ('). It will show in the formula bar
but not in the cell,
Regards,
Alan.
wrote in message
oups.com...
I'm a new Excel user, using XP office excel. Well, I am trying to enter
some text in the cells. Andormeda Galaxy is of type G - Sb. When I
enter G- Sb, excel thinks it is some formula. The same thing with the
coordinates like latitude and longitude numbers. How can I enter the
data AS IS: and NOT AS A FORMULA.

Thanks

Shanks

Bernard and Alan: Thanks a bunch.

Format Cells Text


" wrote:

I'm a new Excel user, using XP office excel. Well, I am trying to enter
some text in the cells. Andormeda Galaxy is of type G - Sb. When I
enter G- Sb, excel thinks it is some formula. The same thing with the
coordinates like latitude and longitude numbers. How can I enter the
data AS IS: and NOT AS A FORMULA.

Thanks

Shanks