Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text with link
I have date in cell a1 with dd-mmm-yy format.
On the same sheet, I have another cell with "Allocation for " & A1 The result gives me Allocation for 39512 Required result is Allocation for 05-Mar-08 I dont understand why excel is unhappy with my format of dd-mmm-yy Any ideas? Regards, Madiya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link in Text box | Charts and Charting in Excel | |||
link text | Excel Worksheet Functions | |||
Link to text and return text into a formula? | Excel Worksheet Functions | |||
Text Box Link | Excel Programming | |||
I want to link, not just copy,Word source text to a text box in Ex | Excel Worksheet Functions |