Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i enter a negative number sequence with spaces in excel
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". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HO do I enter a number and have it always appear negative | Excel Discussion (Misc queries) | |||
Excel Enter Key Sequence? | Excel Discussion (Misc queries) | |||
Enter credit (negative number) in sales template | Excel Discussion (Misc queries) | |||
How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) |