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 :-)