Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a format in a formula
Any advice on the following would be appreciated.... I have a formula that concatenates text and another formula that stript the date from another cell. Example: ="On order is as of: " & formula that strips date from another area My issue is the result is On order is as of 31245872 I want the result to be On order is as of 7/29/06 I set the format of the cell to a date format but with the leading text it does not work. Can I set the format within my formula??? Thansk, Rudy -- rudy ------------------------------------------------------------------------ rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911 View this thread: http://www.excelforum.com/showthread...hreadid=567594 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a format in a formula
="on order is as of: " & text(a1,"mm/dd/yyyy")
rudy wrote: Any advice on the following would be appreciated.... I have a formula that concatenates text and another formula that stript the date from another cell. Example: ="On order is as of: " & formula that strips date from another area My issue is the result is On order is as of 31245872 I want the result to be On order is as of 7/29/06 I set the format of the cell to a date format but with the leading text it does not work. Can I set the format within my formula??? Thansk, Rudy -- rudy ------------------------------------------------------------------------ rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911 View this thread: http://www.excelforum.com/showthread...hreadid=567594 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a format in a formula
That works! I am a tool. I saw the text function in Help but didn' have the "mm/dd/yy" at the end. Thanks for the help -- rud ----------------------------------------------------------------------- rudy's Profile: http://www.excelforum.com/member.php...fo&userid=3391 View this thread: http://www.excelforum.com/showthread.php?threadid=56759 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting special format for a cell | Excel Worksheet Functions | |||
Setting the date format | Excel Discussion (Misc queries) | |||
need help setting a simple format to keep rent. | New Users to Excel | |||
sETTING A SPECIAL FORMAT | Excel Programming | |||
setting format in vb | Excel Programming |