S
STING
How do you get the single quote mark to show up in a cell" I am trying to
round Degrees-minutes-seconds to degrees-minutes. When I extract all the
components of the "Degree-minute-seconds" string (with the =mid function) out
into individual cells to do the rounding and then concatenate them back
together as "Degrees-minutes" the single quote (the minute mark) does not
show up in the cell by itself and therefore does not show up when
concatenated.
My temporary fix is just to place 2 single quotes in a cell instead of
extracting it with the =mid function, but I still want to know why it doesn't
work the other way and can I make it work, can you disable the logic that
associated the single quote with right justification?
round Degrees-minutes-seconds to degrees-minutes. When I extract all the
components of the "Degree-minute-seconds" string (with the =mid function) out
into individual cells to do the rounding and then concatenate them back
together as "Degrees-minutes" the single quote (the minute mark) does not
show up in the cell by itself and therefore does not show up when
concatenated.
My temporary fix is just to place 2 single quotes in a cell instead of
extracting it with the =mid function, but I still want to know why it doesn't
work the other way and can I make it work, can you disable the logic that
associated the single quote with right justification?