half Of ICWAI Help
Sent: Thursday, June 30, 2011 7:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How To Concatenate the Cell without loosing
the format
="$"&ROUND(B3/1000,0)&" "&"GMRR"&""&"("&ROUND(D3,
*="$"&ROUND(B3/1000,0)&" "&"GMRR"&""&"("&ROUND(D3,2)&"%"&""&"of the Plan)"*
*find the attached file and formula it will works .
*
On Thu, Jun 30, 2011 at 5:58 PM, Monu Tiwari wrote:
> Awesome . thanks everyone !
>
>
> On Thu, Jun 30, 2011 at 3:14 PM, ankur wrote:
>
>> hi ak
>> file is attached f
Awesome . thanks everyone !
On Thu, Jun 30, 2011 at 3:14 PM, ankur wrote:
> hi ak
> file is attached for reference
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Thu, Jun 30, 2011 at 3:10 PM, ankur
hi ak
file is attached for reference
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jun 30, 2011 at 3:10 PM, ankur wrote:
> hi AK , use this formula, may it fullfill ur requirement use in F3 cell
> =TEXT((C3
hi AK , use this formula, may it fullfill ur requirement use in F3 cell
=TEXT((C3/1000),"$#,#00")&"K"&" GMRR ("&ROUND((E3*100),0)&" % of the plan)"
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jun 30, 2011
Hi Ak,
Find attached your query resolved
*Best Regards,*
*Venkat*
On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari wrote:
> Hi Experts,
>
>
>
> I want to concatenate the different cells without losing the format of the
> cells. Please refer the excel sheet for more details.
>
> Thanking you
Hi Experts,
I want to concatenate the different cells without losing the format of the
cells. Please refer the excel sheet for more details.
Thanking you in Advance.
Regards,
AK
--
--
Some important links for
