Custom Number Format

  • Thread starter Thread starter KLondike-5
  • Start date Start date
K

KLondike-5

I'm sure this has been asked before but I combed through the archives and
could not locate an answer.

I want to set up a custom number format so that the cell will display in a
percentage format if it's contents are less than 1 and a currency format if
the value is equal to or greater than 1. The version is Excel 2000.

Thanks!
 
Something like:
[<1]0.00%;[>=1]$0.00;General

What happens at 1? I chose to use $0.00.
 
Back
Top