Post Reply 
HMS numbers in the Spreadsheet App [SOLVED]
09-03-2018, 06:16 PM
Post: #2
RE: HMS numbers in the Spreadsheet App
(09-03-2018 05:51 PM)JMB Wrote:  I was working with the Spreadsheet App, when I found that HMS numbers cannot be entered directly into cells, because the [shift] [a b/c] key does not work.

I want to enter 8°30' in cell A1, so I press [8] and then [shift] [a b/c], but this key does nothing (the ° does not appear after the 8).

I have found two workarounds:
  1. Inside the Spreadsheet App I can Type →HMS(8.5) [Enter], and I get 8°30'00" in cell A1.
  2. In HOME I type 8°30' using [shift] [a b/c] as usual, then I start de Spreadsheet App and use [shift] [Menu] to paste 8°30' from HOME into cell A1.

So is it really not possible to use [shift] [a b/c] inside the Spreadsheet App, or am I doing something wrong?

I use the template key (It's also Shift Units or Alpha C)
HMS template is in the lower right corner
It gives you all of the separators at once,
but you have to move the cursor
Find all posts by this user
Quote this message in a reply
Post Reply 

Messages In This Thread
RE: HMS numbers in the Spreadsheet App - CyberAngel - 09-03-2018 06:16 PM

User(s) browsing this thread: 1 Guest(s)