I am a traffic accident investigator and I am using excel to transcribe
handwritten measurements for legible printing. The format used is to
write the feet in normal script and the inches in underlined
superscript. Nothing happens with these numbers except for printing.
(Sometimes I have thousands of measurements to transcribe, so a macro
will make entering them much easier.) I have tried your code, but it
doesn't seem to work. The cells, "C5:D60" are merged (i.e., C5,C6 is
one, D5,D6 is another, etc.) in both columns. Should I unmerge the
cells, or is there a way to make this work? Thanks for all the help.
BTW, it doesn't matter how the cell is formated, text or numbers, it's
the appearance that matters. Thanks for all of your help!