Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I can employ this number format
[=1]# "month";[1]# "months" so that if I enter 1 in a cell it will display : 1 month but if I enter 2 it will display : 2 months. what I want to do is use that same format as part of the Text function (I'll eventually be employing it as part of a concatenated string). i.e. =TEXT(A1,"[=1]# "month";[1]# "months"") but the problem is obviously that using quotes to signify the text suffix, is throwing out the syntax for the function. I can get round it the long way using IFs, but it's clunky. Is there some secret excel guru juice that will help me out? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel---how do i automate adding a suffix to text? | Excel Discussion (Misc queries) | |||
What is the syntax for function text parameters in VBA (Excel 07) | Excel Worksheet Functions | |||
Help with sorting numbers with text suffix | Excel Discussion (Misc queries) | |||
conditional format for text | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |