View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default how do i enter a negative number sequence with spaces in excel

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


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"belbeason" wrote:

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