Thank you very much.

It's on it's way.

Steve

"Glenn" wrote:

Can not reproduce the error with information you are providing. If you like,
email me a *SMALL* sample worksheet with the error and I'll take a look at it.
Send to glennschwandt at yahoo dot com.

Steve wrote:
#VALUE! -
=--TRIM(RIGHT(SUBSTITUTE(TRIM(A3),":",REPT(" ",10)),10))
The above is the data in the #Value! cell via the formula bar.

"Glenn" wrote:

Copy the value from A3 (the one that results in #Value!) directly into a
response to this post. Do not re-type or edit in any way.

Steve wrote:
This
=--TRIM(RIGHT(SUBSTITUTE(TRIM(A3),":",REPT(" ",10)),10))
Gives me a #Value!
Also isnumber for that cell is false.

Thanks,

Steve

.

.