Thread: Custom Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RichardSchollar RichardSchollar is offline
external usenet poster
 
Posts: 196
Default Custom Format

Hi

I seem to get it to work with:

[<=0]General;[<0.1]"NMF";General

Hope this helps!

Richard



wrote:
[<0.1]"NMF"; 0.0

returns -NMF if it is negative though I just want NMF if it is <.01

Thanks in advance for any help.