Is it possible to format cells as 'show me the decimal places, but only if they're there'? That way $2.00 is $2 but $2.34 is $2.34.
I would use
=if(A1=(last 2 digits are zeros),A1 but without the zeros,A2)
But how do I set this up?
Is it possible to format cells as 'show me the decimal places, but only if they're there'? That way $2.00 is $2 but $2.34 is $2.34.
I would use
=if(A1=(last 2 digits are zeros),A1 but without the zeros,A2)
But how do I set this up?
In cell format (Ctrl+1) use this custom format
$General
Life's a spreadsheet, Excel!
Say thanks, Click *
Halfway there. What about keeping the comma separators, and either both or neither decimal places? So what's now $1200.5 becomes $1,200.50?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks