I have searched this forum and the web and am not finding the answer.
I have a local report using the Microsoft Report Viewer add in for VS 2005 Express. I am trying to format a text field in a report that is a telephone number.
Instead of 8008898890 I want (800) 889-8890
Any suggestions? I have tried all of the format options such as {0:(###) ###-####}
None of them are working.
Joe
For anyone who is wondering here is the answer:
=Format(CDbl(Fields!yourfield.value), "(###) ###-####")
No comments:
Post a Comment