Convert Number to Text

[#1]

In Need to convert a number to text without de decimal part.

When i try to convert with TEXT() function a number:

Text(IdUser)

i have this value 129.000000, i need only 129

any idea?

Thanks.

[martin59]

hi,

Have you tried something like this ?

text(round(IdUser,1))

Hope that helps you

[tresesco]

try this:

Text(Floor(IdUser))

Regards, tresesco

[#4]

Hi,

Consider the example:

Data:

LOAD * INLINE
[
EmplNo,Amount
001,129.000
002,130.000
003,154.000
004,186.000
005,169.000
];

=text(round(Amount))  in your expression.

This should solve your problem.

Regards,

Snehal Nabar

[SunilChauhan]

Trim('  '&abs(Amount))

or

text(Trim('  '&abs(Amount)))

hope this helps

[#6]

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

[#7]

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

[#8]

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

[#9]

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

[#10]

Hi,

Please mark this post as answered, If it has solved your query.

Regards,

Snehal Nabar