Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    May 2012
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wrap Text function treats negative sign like a hyphen

    How can I format a cell with of lat/long values (i.e. a positive value, a negative value) with text wrapping
    so that the wrapped cell, in two rows, keeps the hyphen with the negative value?

    Please see attached spreadsheet

    (I hope I attached correctly...)
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    1,020
    Thanks
    61
    Thanked 111 Times in 96 Posts
    I don't know if this works for you, but I replaced the - with (slightly longer !) and the wrapping now shows the text how you want it.

    See attached.
    Attached Files Attached Files

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,053
    Thanks
    145
    Thanked 544 Times in 519 Posts
    Hi yoree

    Aside from Martin's solution, you can force wrapping at any time by pressing [Alt][enter] after the comma.
    This will place subsequent data on a new line.

    zeddy

  4. #4
    Star Lounger
    Join Date
    Oct 2012
    Posts
    55
    Thanks
    1
    Thanked 10 Times in 10 Posts
    Hi yoree

    Why don't you keep the Lat/Long in their own cells, at least they will be numbers and you can still use them. Adding "," etc they are then text!

    Kevin

  5. #5
    New Lounger
    Join Date
    May 2012
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks 3 Star! I replaced the hyphen with ALT-0150 (n-dash) - PERFECT!!!

  6. #6
    New Lounger
    Join Date
    May 2012
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks (and sorry for late response)

    Thanks MartinM and Zeddy for the tips!

    And, yes, I agree with you, Keven, converting real information (numbers) to text is never a good idea, but the "client" wins, in this case... until Excel comes up with a Lat/Long format. Hmmmm.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •