I have a range of cells A1:A10 in which data is pasted from AS400. Th
data is pasted in a 2340- format for a negative number. What I'
looking for is when the data is pasted into these cells, for excel t
automatically change the format from 2340- to <2340.

Thanks.

e

--
edwardpestia
-----------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...fo&userid=3380
View this thread: http://www.excelforum.com/showthread.php?threadid=55636