View Single Post
  #5   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

Thx, allmost right:

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


"JE McGimpsey" skrev:

One way:

=TEXT(H7,"0.0 pct.")

In article ,
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." ?