We help IT Professionals succeed at work.

format number

maximyshka
maximyshka asked
on
Medium Priority
720 Views
Last Modified: 2013-11-28
Hi.  I use in txbox of the report following expression: =Format([Weighted_DSC],"#,###.00")

If number is <0, Access displays .90
How can I get Access to display 0.90
Comment
Watch Question

Director of Software Engineering
CERTIFIED EXPERT
Commented:
format (number,"#0.00")
Commented:
Use =format([Weighted_DSC],"#,##0.00")
Shanmuga SundaramDirector of Software Engineering
CERTIFIED EXPERT

Commented:
or format (number,'#0.00'). Hope this helps
Shanmuga SundaramDirector of Software Engineering
CERTIFIED EXPERT

Commented:

Explore More ContentExplore courses, solutions, and other research materials related to this topic.