Its a computer generated linked in futures contract table price: low,
high, close, previous, i encounter this #N/A N.A., in low and high, but
it's normal there is no figure on low & high column price sometimes, but
instead of #N/A N.A., i wanted to replace with "----", to make
appropriate to look, which means, the low and high price data is not
available. I hope this is clear for you.


--
jolly79_ph
------------------------------------------------------------------------
jolly79_ph's Profile: http://www.excelforum.com/member.php...fo&userid=4835
View this thread: http://www.excelforum.com/showthread...hreadid=499652