Re: Text with link by Ron
Ron
Sat Mar 15 07:02:56 CDT 2008
You're welcome.....I'm glad I could help.
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Madiya" <madiya122@yahoo.co.uk> wrote in message
news:cef00379-6604-4c0c-b61e-6322c84539be@e10g2000prf.googlegroups.com...
On Mar 14, 6:25 pm, "Ron Coderre" <ronREMOVETHIScode...@bigfoot.com>
wrote:
> To Excel, dates are represented by the
> number of days the date is from 31-DEC-1899.
>
> 01-JAN-1900 is 1
> 11-MAR-2008 is 39,521
>
> When you format a cell as date, Excel is only *displaying*
> the number in a format that humans can understand is a date.
>
> So, you'll need to convert the number to text.
>
> Try this:
> ="Allocation for "&TEXT(A1,"dd-mmm-yy")
>
> Does that help?
> Post back if you have more questions.
> --------------------------
>
> Regards,
>
> Ron
> Microsoft MVP (Excel)
> (XL2003, Win XP)
>
> "Madiya" <madiya...@yahoo.co.uk> wrote in message
>
> news:a218a26a-56fe-4972-84de-071580ee9a19@i12g2000prf.googlegroups.com...
>
>
>
> >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- Hide quoted text -
>
> - Show quoted text -
Perfact.
Thanks.
I was trying with format and date instead of text.
Regards,
Madiya