Thread: Displaying decimal places
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel
Bernd Bernd is offline
external usenet poster
  
Posts: 92
Default Displaying decimal places
Hello,

Without VBA you will need a helper cell:
=TEXT(A1,"0"&IF(A1<10,".0",""))

Regards,
Bernd

Reply With QuoteReply With Quote