[rascl]

Hi Cindy,
Thank you for your continued support! I have copied the formula below
however yesterday our IT dept. (different person) determined that not
only was something wrong with my network connection but apparently
some?thing wrong with my pc. 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(:

At any rate I am still interested in the text to column matter if you
wouldn’t mind replying even though its no longer as urgent a need for
me (so far).
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)))

Thanks for all your help!!(:
rascl

[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!!