Posted by Chris D on January 31, 2002 2:32 PM
Years ago (like in 1995) my old boss set up a spreadhseet that automatically turned positive numbers into negative numbers as you typed them in...
so you typed "123.45" and it entered them as "-123.45"
Now, I want to do the same in a particular column of this spreadsheet and can't figure how he did it, I'm sure it wasn't a macro as that would have been beyond him in those days....
Can anyone help with a suggestion ?