Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of digits when merged with text
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." ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of digits when merged with text
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." ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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." ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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." ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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." ? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of digits when merged with text
Your change isn't right at all, given that your example used a decimal
point, not a comma. It's also inefficient - there's no need to add operators and do string manipulation. - '&' is the concatenation operator, the '+' is redundant. - it can be done in one step with the notation you're using: =TEXT(I6; "0,0 pct.") In article , Rasmus wrote: Thx, allmost right: =TEXT(I6;"0,0") & + " pct." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return first 3 digits of a number? | Excel Worksheet Functions | |||
Sum of digits in a number | Excel Worksheet Functions | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
How do I view all text in a merged cell? Wrap text is activated. | Excel Discussion (Misc queries) | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) |