View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How to display percentage with 0 decimal point by Text function?

On Tue, 8 May 2007 07:36:00 -0700, Eric wrote:

Does anyone know how to use Text function to display percentage with 0
decimal point? such as
0.5 displays in cell A1, in cell B1, how to write the code Text(A1, ???) in
order to display 50% in cell B1?
Thank for any suggestions
Eric



=TEXT(A1,"0%")
--ron