a very simple question

  • Thread starter Thread starter gireesham
  • Start date Start date
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
 
Type a single quote (apostrophe) before you type the test
OR
Format the cells for Text before typing
best wishes
 
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.
 
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.
 
'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...
 
Back
Top