LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default Formatting columns for Lat-Long

Yeah, that's a good point... I only looked at Arial font.

--
Rick (MVP - Excel)


"Jon Peltier" wrote in message
...
Rick -

It was a long time ago I settled on 0176, so I don't recall the details. I
was probably using a different font, one I never use anymore, and I'm sure
that also makes a difference.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rick Rothstein" wrote in message
...
Your comment prompted me to test both of them side by side. Actually,
Alt+0186 makes the larger circle (I bumped the font size up to 48 to
examine them); that is the difference I didn't notice earlier... one is
not higher than the other, only larger (the top of both symbols are
located at the same height position; it was the size difference that made
one look like it was higher than the other one).

As it turns out, though, neither one of them is exactly the right one to
use.<g The symbol produced from Alt+0176 is the same height as the
apostrophe and quote mark symbols, but its line thickness is just ever so
slightly little thinner than them. On the other hand, the symbol produced
from Alt+186 is larger than the apostrophe and quote mark (about 25% so)
and its line thickness is just ever so slightly heavier. At normal font
sizes, I kind of think Alt+0176 looks a little bit better (but that is a
highly subjective opinion).

--
Rick (MVP - Excel)


"Jon Peltier" wrote in message
...
I've always used Alt+0176. The other always seemed to make too small a
circle.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rick Rothstein" wrote in message
...
To get the degree sign, hold down the ALT key and enter 0186 on the
numeric keypad (to the right of the keys, NOT the numbers above the
letters).

Hmm! I posted the same message as you did, but I instructed the OP to
use Alt+0176 instead of Alt+0186. They both look like degree symbols to
me, but one seems to display the circle a little higher up than the
other. Do you know what (beside the height thing) is the difference
between these two symbols? Is one of them a degree sign and the other a
something else (and if a something else, what)?

--
Rick (MVP - Excel)








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo Max Loger Excel Discussion (Misc queries) 0 June 14th 11 04:30 PM
putting 2 long columns into multiple columns in excel page and sor bob_mhc Excel Discussion (Misc queries) 1 April 25th 08 07:51 AM
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 2 July 31st 06 09:45 PM
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 0 July 31st 06 05:07 PM
Make 2 long columns into 8 shorter columns Mike Fogleman Excel Programming 1 December 23rd 03 04:58 AM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"