Thread: Number of digits when merged with text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Number of digits when merged with text
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." ?
Reply With QuoteReply With Quote