a very simple question

G

gireesham

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
 
B

Bernard Liengme

Type a single quote (apostrophe) before you type the test
OR
Format the cells for Text before typing
best wishes
 
M

mmb

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.
 
A

Alan

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.
 
A

Alan

'Text1'
Idiot (me)
'Text'
Alan.
Alan said:
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.
Click to expand...
 
Top