| Home |
| Search |
| Today's Posts |
|
#4
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." |
| 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) | |||
Threaded Mode
