View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default conditionally format anumber format

Not quite, but as close as I can get

[<1].00c;$#,##0.00


It looks like you can get the cent (¢) sign by typing Alt+0162 from the
number pad in place of typing the letter c; however, it looks like we are
stuck with that decimal point.

Rick