[Cindy M.]

Hi Rascl,

They gave me a new pc & plugged me in to a
different network line. The problem(s) hasn’t re-occurred as yet. My
values are again displaying correctly without doing the confirm
conversion at open however that’s where the original problem started
and why I went to the confirm conversion in the first place… I’m not
entirely convinced that the problem wont re-occur but I’m hoping(:

OK, DDE is back in business - enjoy it while it lasts :-)

At any rate I am still interested in the text to column matte

Let's see what we can work out...

Here is my formula:
=IF(ISBLANK(VLOOKUP(A1770,'C:\Product Support\Warranty\2006 Warranty
Reports\Claims\[2006 Warranty Claims .xls]Warranty
Claims'!$A:$N,14,FALSE))," ",(VLOOKUP(A1770,'C:\Product
Support\Warranty\2006 Warranty Reports\Claims\[2006 Warranty Claims
.xls]Warranty Claims'!$A:$N,14,FALSE)))

That's a "mouthful" :-)

This is what I'd try. Note that I'm giving it a 0.00 numbering style
(at the end, before the closing parenthesis), but you can substitute
whatever you like. The important thing is that there's something:

=TEXT(IF(ISBLANK(VLOOKUP(A1770,'C:\Product Support\Warranty\2006
Warranty
Reports\Claims\[2006 Warranty Claims .xls]Warranty
Claims'!$A:$N,14,FALSE))," ",(VLOOKUP(A1770,'C:\Product
Support\Warranty\2006 Warranty Reports\Claims\[2006 Warranty Claims
.xls]Warranty Claims'!$A:$N,14,FALSE))), "0.00")

Note: If I'm reading this correctly, the problem may be with the
"True" section. You're setting this to a space? Then a number format
may not be accepted, or may give you a result you don't want. In that
case, try something more along these lines:

=IF(ISBLANK(VLOOKUP(A1770,'C:\Product Support\Warranty\2006 Warranty
Reports\Claims\[2006 Warranty Claims .xls]Warranty
Claims'!$A:$N,14,FALSE))," ",Text((VLOOKUP(A1770,'C:\Product
Support\Warranty\2006 Warranty Reports\Claims\[2006 Warranty Claims
.xls]Warranty Claims'!$A:$N,14,FALSE)), "0.00"))

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

[rascl]

Thank you! Thank you! I will try that asap!!
-currently very behind due to all the problems I was having.

Note: If I'm reading this correctly, the problem may be with the
"True" section. You're setting this to a space?

The only reason I set "true" to a space is so that I will get no
display if there is no value available, instead of 0 or n/a showing up
in my form letter. There is probably a better way (?) and maybe not so
harry of a formula but I don’t know about one yet... I'm pretty much
self taught .. rather, I started out swiping formulas and figuring them
out so I could use them|: I have minimal classes taken now but none so
far that focus on writing formulas ..
Thank you a million times !! I look forward to trying your suggestion
asap!!