Huge Problem with value format !! My work depends on that!

[stakar]

Huge problemmmmm!!

I get one value as a result from vb code formatted with the Cstr
and one value using an excel formula
(the results for both values are always the same numbers)

When the values are 00 or 01 or 015 or 1510 etc, are identical an
recognize each other
When the values are 0 or 1 or 8 or anything but two and more digit
value, aren't identical because the not vb value isnt a text

I use the =isnumber()

The value that comes from the vb code is always FALSE
The value that comes from the excel formula when it is 00 or 01 i
FALSE but when it is 0,2,7 or anything but below 10 is TRUE

Can someone tell me which is the format for the not vb value to b
always a string

 

[mk]

The value that comes from the vb code is always FALSE

The value that comes from the excel formula when it is 00 or 01 is
FALSE but when it is 0,2,7 or anything but below 10 is TRUE

Try =TEXT(your_number;0).
=ISNUMBER(A1) (if the above formula in A1) returnes FALSE

 

[stakar]

*> The value that comes from the vb code is always FALSE

Try =TEXT(your_number;0).
=ISNUMBER(A1) (if the above formula in A1) returnes FALSE

Its no use
When i use this i get FALSE but i cant get the string as it is
eg.
If the A1=0 its ok
If the A1=01 its not ok because i get 1 instead of 01
if i change the =TEXT(your_number;0 -> 00)
i get the 01 as 01 but the 1 as 01 too

 

[mk]

Its no use

When i use this i get FALSE but i cant get the string as it is
eg.
If the A1=0 its ok
If the A1=01 its not ok because i get 1 instead of 01
if i change the =TEXT(your_number;0 -> 00)
i get the 01 as 01 but the 1 as 01 too

Then what about?:

=TEXT(A1;REPT("0";LEN(A1)))

 

[stakar]

thank you for your replay
I just solve the problem using vb cod