Thread: format as %
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default format as %

? format(.2345,"#.0%")
23.4%



--
Regards,
Tom Ogilvy

"saziz" wrote in
message ...

Hi All,
What would be the syntax for format(my formula,"percent")?
Help appreciated
Thanks
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile:

http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=477349