Thread: Displaying decimal places
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
John John is offline
external usenet poster
  
Posts: 2,069
Default Displaying decimal places
have a look at http://peltiertech.com/Excel/NumberFormats.html
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"KnowledgeSeeker" wrote:

Is there a way for me to have the data in a cell determine how many
decimal places should be displayed? For example, if the formula in
the cell results in a number that is greater than (or equal to) 10,
then I'd like to have zero (0) decimal places actually displayed.
However, if the formula in the cell results in a number that is less
than 10, I'd like to have zero (0) decimal places displayed.

Thanks for your help.


Reply With QuoteReply With Quote