SO-MJH@finou.oulu.fi (10/05/90)
I've got a huge Excel 2.1c sheet under Windows 3. The data was originally imported from 1-2-3 and it contains lists like this (each line represents a cell): Text -blah -blah -blah blah Everyone knows that you need to enclose a string beginning with '-' /w double quotation marks and type an equal sign in the beginning since Excel won't recognize the cell contents as a string otherwise. The trouble is that I have hundreds of cells like '-blah blah' on the sheet and if I change the text in any way I need to type in '="-blah blah blah"'. This is a bit clumsy because there is another character which looks exactly the same as minus sign but Excel does not treat it as minus. This character has code 173 versus 45 of the minus sign. The trouble is how to type in the hyphen without send.keys macro command. +-------------------------------+ +-----------------------------+ | Mika Hepoviita | | | | SO-MJH@FINOU.OULU.FI | | Jai guru deva om | | University of Oulu, Finland | | | +-------------------------------+ +-----------------------------+
ckinsman@eecs.wsu.edu (Chris Kinsman - EE major) (10/07/90)
I wrote a macro to do this conversion. If need be I could post it. It is relatively short.