View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Brotherharry Brotherharry is offline
external usenet poster
 
Posts: 21
Default convert number to % using only custom number format challenge

Aha, that's exactly what I was looking for.

I multiplied my % values by 100,000 and plotted them directly,
removing the marker points and lines, but adding formatted data labels
using your custom number format. Lose some control over the position,
but adequate for my needs right now.



On Jun 2, 11:19*am, Ron Rosenfeld wrote:


You could multiply your percent figure by 100,000; and then use this custom
format:

0.0,\% *(to display with one decimal).

--ron