View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default formatting question

thanks Bobs,

21
21.1
21.15
21.154
21.1546

My bad, I have not shown the purpose very clearly .

Actually, format "#,##0.####" fits well even with "." shown after 21.

Yet, I need to present the visual result showing the numbers with excessive
decimals.
Is it possible to have all these <column numbers be shown with all the "."
<periods be aligned vertically ? In this case, I may not need to use the
conditional format.

--
regards