Thread: Display currency as calculated
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
  
Posts: 99
Default Display currency as calculated
Hi Gav,

You have to specify the number of digits remaining
Try:
=Trunc(22.63/11, 2)

HTH,

Wouter

Reply With QuoteReply With Quote