TRUE / FALSE.

[serge]

Hi,

I'm having a problem converting my numbers from FALSE to TRUE.
I have this number in cell TS5 that is =ISNUMBER ) FALSE , that I want to transfer to TRUE so I =TS5*1 and it return it TRUE but it look like this 2.10321E+15 which doesn't work for me so I tried the same then I go format cell to Number then it works BUT the number change a the end it return it as 2103210321032100 the last digit is round up to 0 instead of be 3 ???

How can I convert my numbers to TRUE and return intact ?

Thank you.

 

[Zot]

This will answer your question

Redirecting

 

[serge]

Thank you Zot,

I don't need to do calculation with it, it's just for a reference formula, when I use my =LOOKUP(CJ8,'Ref Table2'!$TX$5:$TY$6565) it doesn't work if it's not TRUE !!!
Is there a diferent way to use my LOOKUP formula to make it work ?
Thank you.

 

[serge]

That's ok Zot, I can manage using it the way it is, Thank you for your help.

 

[Alex Blakenburg]

What you are saying seems to be inconsistent. Since Excel can't show the full 16 digits as a number, it doesn't seem to make sense that CJ8 is showing as a number.

Are all the values in TS text ?
If they are you could try

=LOOKUP(TRIM(CJ8),'Ref Table2'!$TX$5:$TY$6565)

( "" & CJ8) should work too)
Can you provide and XL2BB of what is in CJ8 a in TX:TY (sample rows only) ?

 

[serge]

Thank you Alex for your answer.
CJ8 is formatted as NUMBER but I loose the 16th digit that become a 0, the same for TX:TY also formatted as NUMBER and also loose the 0 at the end, from my CONCATENATE formula , but it's Ok I can work around it, loosing the 16th digit.
I would rather keep it to be more exact but it still work for what I do.

I do not have XL2BB I tried some time ago to installed it without success, maybe because I'm running Office 2007, I don't know.

Where can I find a link to install it ? I would try again.
Thank you for the help.

 

[MARK858]

I do not have XL2BB I tried some time ago to installed it without success, maybe because I'm running Office 2007, I don't know.

Where can I find a link to install it ? I would try again.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[serge]

Thank you MARK858.

 

[Alex Blakenburg]

If the whole column is just a reference id then consider bringing the data in as Text and format the column as Text (so future changes are also kept as text).
Do the same for CJ8 and your lookups should work and you should not have an issue with losing digits ?