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