Importing data

T

TERRY TILLER

When I import sales data through 3CDaemon, I get cells that I of data that I
cannot use in formulas. It is like they are corrupted. But can copy the
info from cell to cell, just cannot use in formula (ex. =if(dd04="N",1,0.
Formula does not error out, but it makes no difference if N, U, or anything
else is in dd04. It answers back 0. How can I fix this ?
 
D

Dave Peterson

Just a couple of guesses (I have no idea what 3CDaemon is).

First, Get a copy of Chip Pearson's CellView Addin so that you can really
determine what's in DD04):
http://www.cpearson.com/excel/CellView.htm

Second, when I type a formula like:
=if(dd04="N",1,0)

The DD is changed to uppercase and the 0 is dropped:
=IF(DD4="N",1,0)

Does 3CDaemon create any bad (range) names (things that look like addresses)?

Try toggling this on, then off.
Tools|options|general tab|R1C1 reference style.

If you get a dialog box popping up saying that the name needs to be replaced,
you've found the source of your problem (maybe not the solution, though.)



There's an option that behaves kind of like what you write (but not exactly).

Tools|Options|Transition Tab
Uncheck "Transition formula evaluation"

(I uncheck all these Lotus 123 transition settings!)

=IF(DD4="N",1,0)
will evaluate to 1 if DD4 is empty under this setting.
it'll evaluate to 0 if DD4 is empty and the setting is turned off.)
 
Top