View Single Post
  #1   Report Post  
Onrey
 
Posts: n/a
Default currency different from normal

I would like to have the values in column C formatted in either currency or
accounting, but when I try, all I get is $0.00. Can anyone tell me what to
try (or what I'm doing wrong?)

Thanks!

A B C (formula is =A1/B1)
$160.65 2,036,204 7.88945E-05
$154.80 1,993,844 7.76371E-05
$167.37 1,846,142 9.06608E-05