Thread: Why do I get a result that looks like this? 298023E-09
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PJFry PJFry is offline
external usenet poster
  
Posts: 143
Default Why do I get a result that looks like this? 298023E-09
It represents the number .00000000298023. Set your format to Number with
decimals out to 15.

PJ

"Jim" wrote:

I am using the xirr function and I get a result of 298023E-09. Why and what
does it mean?
Thanks, Jim
Reply With QuoteReply With Quote