the numberformat = "@" only gives positive numbers. how can i represent a negative number in a cell?
Excel - NumberFormat for negative numbers
the numberformat = "@" only gives positive numbers. how can i represent a negative number in a cell?
I always use @NumberFormat = "#,##0.00;[Red](#,##0.00)"
Below is an excerpt from Microsoft's documentation on the number format property.
Recent badge winners
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
