Format number to text

[system]

Hello,

Is there a way to convert a number into text when I build my variable?

Thank you in advance.
Catherine

---

catherinegaucher (BOB member since 2014-06-05)

[system]

FormatNumber([Revenue];"#,##.00") returns 835,420.00 if [Revenue] is 835,420 

this is used for XI versions from help section of functions in modify mode of webi Report if you are using webi 6 then check the equivalent syntax for this

---

haider (BOB member since 2005-07-18)

[system]

He is asking to convert a number to text and not format the number. for that we can use char(object) to convert into text

---

surya_sudheer (BOB member since 2006-11-01)

[system]

He is asking to convert a number to text and not format the number. for that we can use char(object) to convert into text

He?! I would suggest She.

Surya,

Can you please think before you post, I have noticed that a lot of your answers are either wrong or irrelevant?

We like to be accurate when we post, as this will help others in the future.

Haider is correct here.

Thank you.

Mark.

---

Mak 1 (BOB member since 2005-01-06)

[system]

but she is asking to convert number to text when she creates a variable

---

surya_sudheer (BOB member since 2006-11-01)

[system]

@surya_sudheer

but she is asking to convert number to text when she creates a variable

Yes and that is what FormatNumber does, it returns a string.

---

Mak 1 (BOB member since 2005-01-06)

[MarkP]

@surya_sudheer

He is asking to convert a number to text and not format the number. for that we can use char(object) to convert into text

Char doesn’t do that. Char returns the character associated with an ASCII code, so char(123) returns {

[system]

Just use
=""+[Number]

Hope this will help…

---

PathFinder (BOB member since 2012-01-05)