Harold Fuchs wrote:
On 15/06/2008 04:52, JOE Conner wrote:
<<SNIP>>
Joe,
I'm not sure what you want me to do with your spreadsheet. I'm also
not sure why you say no solution was found to the formatting problem.
Simply assign to a cell in a different column the formula =B6/24
(where B6 is the calculated in-flight TH Air Vector value) and format
that column with [HH]\* MM\" SS\' where I have put an asterisk (*)
instead of the degree sign in case your e-mail program can't handle
that symbol. In the example you sent, the value shown, 177.74, appears
in this extra column as 177* 44" 24' where again I've used an asterisk
instead of the degree symbol.
You can put a degree sign into the format string via Insert Special
Character. Copy the symbol into a spare cell, copy that and paste it
into the format string. Of course this is just a one time process;
once you have the right format you can re-use it as needed.
I've attached a small example - just two cells and the format string
defined in the User Defined section.
Thanks Harold.
I really was not expecting you to do anything with my spreadsheet, it
was just illustrative of my problem.
Best regards,
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
