On 14 Jun 2008 at 12:40, Harold Fuchs wrote: > 2008/6/14 mike scott <[EMAIL PROTECTED]>: > > > On 14 Jun 2008 at 9:37, Harold Fuchs wrote: > > > > > 2008/6/14 JOE Conner <[EMAIL PROTECTED]>: > > > > > > > In Calc I would like to format a cell containing a number such as > > 189.25 to > > > > display such as 180 15. > > > > This can represent 189 and 1/4 degrees displayed as 189 minutes 15 > > seconds. ... > > > > (I assume, btw, the op wants to display "189 and 1/4 degrees" > > displayed as "189 degrees 15 minutes" though, and not as stated!! ) > > > You can include text in the format string. So, for example (using <> as > quotes for the purposes *only* of this message) <[HH]\° MM\"> gives <189° > 15"> and <[HH] "degrees" MM "minutes"> gives <189 degrees 15 minutes>. The > backslashes merely "escape" the degree sign and the double quote (minute) > sign.
Yes, I know. But since the [] construct isn't documented (& how on earth did you think to use this!!) I wonder what else is tucked away. But I was really commenting in passing on the OP's typo. If he really wants his angles formatted like that, he's going to lose his way rather quickly :-) > > > > > > > But it's a nasty hack. The number format stuff should be flexible to > > allow this formatting directly. > > > Motion seconded. I'm surprised there is no formatting for > degrees/minutes/seconds. Yes. If bugzilla weren't so confusing I'd log an feature request. Angles are hardly bleeding edge technology. -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED] Mike Scott, Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
