how do i enter a negative number sequence with spaces in excel

B

belbeason

I need to enter latitude/longitude numbers into excel spreadsheet. So I need
to begin a cell with a "-" with spaces also. Excel keeps trying to make it a
formula. For example I need to enter into a cell "-89 66 58".
 
L

Luke M

Possible ideas:

Format cell as text first, and then input data.

Use a custom number format of
00 00 00
and input your numbers without spaces.

Or, type a single quotation mark before you begin typing
as entered in formula bar:
'-89 66 55
will display:
-89 66 55
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top