Type of Data

G

greatheavy

Hello Guys,

I have a not-so-interesting issue, but damn frustrating:

Let say I import a lotus Notes file (format wk4). Now if I do an
formula such as concatenate, or sum, or whatever, it either gives m
back #Value, or O...

Now if I click in the cell, and then validate, it works...

I'm not real good in magic, but I do have very little patience, an
clicking in 2053 cells doesn't sound right...

Any Idea???

Another question, how can I replace a value to be treated as a text (b
adding ' in front of the cell?) => Replace * by '* doesn't work...
know search with * do work, but replacement don't... Does concatenat
the only option???

Again, thanks for your help.


Ale
 
A

Andy B

Hi

To make 'text' numbers into real numbers, copy a blank unused cell, select
your range and then Edit/Paste Special/Add

Hope this helps.
 
Top