Skip to main content

Excel - NumberFormat for negative numbers

  • Jul 17, 2013 2:10 PM UTC
  • 1 reply
  • 11 views

Dominique Sacre
Forum|alt.badge.img+2

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

1 reply

Jim Gramer
  • New Participant
  • Jul 17, 2013 3:50 PM UTC

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.