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
    988
    Thanks
    56
    Thanked 105 Times in 90 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
    2,826
    Thanks
    136
    Thanked 482 Times in 459 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
  •