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

"Ron Rosenfeld" wrote:

On Wed, 20 Feb 2008 18:44:00 -0800, Mike
wrote:

Gary
For some reason my messages are getting an error so no telling how many
replies will show up.
I get an #value! with the formula
Sorry so short on prior post

I will be passing the value to a ADODB.RECORDSET

You will get a #VALUE! error if the "#" token is not in the string being
processed.
--ron