numbers don't add up

[Guest]

after importing some data I am unable to use this data im my formulas untill I edit the data in the cell. ANY IDEAS ?

 

[Mark W.]

Perhaps you're "importing" your numeric values as text (i.e., "10"). Use the Data | Text to Columns... menu command to convert them back to numeric values.

 

[Guest]

that's not the problem its as if there's an unspecified character in the cell
if I do a delete before my entry and after my entry then it works fine

eg [del]12[ lots of dels ]

but nothing shows up as being in those cells
I've used TRIM() to remove spaces but that does not work

 

[Mark W.]

So what are these mysterious characters? Using the array formula...

{=CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))}

...for a value in A1, paste the resultant array constant into a reply posting. You can evaluate with formula in the formula bar using F9.
This message was edited by Mark W. on 2002-02-25 07:36

 

[Guest]

I get a result of 32

 

[Mark W.]

On 2002-02-25 07:53, Anonymous wrote:
I get a result of 32

32 is a space character. What about the rest of the codes?

 

[Guest]

={32;32;32;32;49;55;49;46;32;48}

 

[Guest]

On 2002-02-25 07:57, Anonymous wrote:
={32;32;32;32;49;55;49;46;32;48}

It appears that you have leading spaces and a space after the decimal place. Have you tried using the Replace command to replace " " with "".

 

[Guest]

i spotted this just before you posted but thanks for the help. I do get other similar problems which I can't see an answer to , it may be later in the week before I have to import the data again . If the error occurs I'll post it here again.

Cheers Stephen

 

[Mark W.]

Hang on to the formula that I provided and you can use it to diagnose your problem.