Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report services 2000 format numeric data

Status
Not open for further replies.
Apr 7, 2006
12
CA
The data stores in format:
5.00
2.50
1.25
0.50

I am trying to format data as
5,
2.5
1.25
0.5

I've tried to convert or drop the zeros by formatting the expression
="#,#.##"
The numbers become
5,
2,
1,
0
Any suggestions would be greatly appreciated.

Thank you.


 
Right click on the expression and set the place holder setting of a number to use regional formatting
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top