Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
C5 has a text format and contains, for example, "04-15-2010" or
"12-02-2002" or is empty. How do I write a =TEXT function where "value" refers to C5 and "format- text" returns the contents of C5 with 10-characters (for example: "04-15-2010" or "12-02-2002" or " ")? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM Fuction | Excel Worksheet Functions | |||
i need a fuction | Excel Discussion (Misc queries) | |||
Min Fuction | Excel Worksheet Functions | |||
IF FUCTION | Excel Worksheet Functions | |||
need a fuction that can do this (or can it be done) | Excel Worksheet Functions |