Thread: Displaying decimal places
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Displaying decimal places
"Bernd" wrote...
Without VBA you will need a helper cell:
=TEXT(A1,"0"&IF(A1<10,".0",""))

Wrong. Could use the custom number format

[=10]0;[<=-10]-0;0.0

Reply With QuoteReply With Quote