| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custo Format for TEXT Function
According to Excel help pages for the TEXT function it is possible to use
custom format with the TEXT function. I have tried everything but I can't make it accept colour codes as [Red] etc. Does any one knows why or how ? I know I can use Custom from Format Cells menu or Conditional formating to achive the desired format, but I am interested to make it work with the TEXT function. Thank you PS. I am using Excel 2002 and 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format using TEXT( ) function | Excel Worksheet Functions | |||
| Changing Text format in a function | Excel Worksheet Functions | |||
| Function to display day in text format | Excel Worksheet Functions | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
| TEXT function to format a date in English & French | Excel Worksheet Functions | |||
Threaded Mode
