On Wed, 20 Feb 2008 19:51:01 -0800, Mike
wrote:

Ron I'm getting the value sign and I for sure that there is the "#" in the cell

Copy/paste a cell with your data that is returning the #VALUE error, and also
copy/paste the formula you are using that is returning that error to a message
here, so we can see exactly what is there with no possible typos.

If the cell with the data is from a formula, post that here, too.

Were you able to use the "trace error" option from the little button that might
show up when you select the cell showing the error?
--ron