How to convert Number to String?

[system]

Hi,

I want to convert a number to string.
Is there any function in BO for the same?

I am having the following requirement.
I have a number. I want to display last 2 digits. I want to do this at the Reporting layer.

---

GowthamSen (BOB member since 2006-08-31)

[system]

Hi,

I got the answer from BOB. Here is the link.

120×120 10.4 KB

Thanks!! It was a newbie question, certainly, but a much appreciated and quick response. It worked and shed some light on how to use these functions. Thanks again!! kwc3113 (BOB member since 2008-03-27)

Thanks to Marek.

---

GowthamSen (BOB member since 2006-08-31)

[system]

Hi,

If you want to get only the last 2 digits from the number then use not only FormatNumber() function for a conversion of a number to a string but also Right() function to get the last 2 characters from the string.

The formula should like something like this:

=Right(FormatNumber(<your number variable>,"0"),2)

I hope this helps.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi Marek,

Thank you very much.
I did the same way.

---

GowthamSen (BOB member since 2006-08-31)