Skip to main content

the numberformat = "@" only gives positive numbers. how can i represent a negative number in a cell?

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.