a very simple question

[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

 

[Bernard Liengme]

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

 

[Guest]

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.

 

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

 

[Alan]

'Text1'
Idiot (me)
'Text'
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.

 

[Guest]

Format > Cells > Text

 

[gireesham]

Bernard and Alan: Thanks a bunch.