View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rasmus Rasmus is offline
external usenet poster
 
Posts: 6
Default Number of digits when merged with text

You helped me on the way. Thanks for that,
the right one is:

=TEXT(H7;"0,0") & + " pct."


"Mike H" skrev:

Try

=TEXT(H7,"0.0" & + " pct.")

Mike

"Rasmus" wrote:

Hi

How do i change the number of digits in the cell if I use this:

=H7 & + " pct."

H7 says "8.7" but the cell gives me "8.67452345345 pct." ?