Hi Putta,
Attached herewith is the solved spreadsheet containing two possible
scenarios. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 4, 2009 at 2:38 PM, Putta Madaiah
Thank you Dilip, I appreciate your efforts.
Rgds- Putta
On Tue, Aug 25, 2009 at 4:35 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Putta,
Attached herewith is the solved spreadsheet containing two possible
scenarios. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile:
Hey Putta, thanks for the appreaciting note. . !!
Warm Regards,
DILipandey
On 8/25/09, Putta Madaiah puttamada...@gmail.com wrote:
Thank you Dilip, I appreciate your efforts.
Rgds- Putta
On Tue, Aug 25, 2009 at 4:35 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Putta,
Attached
Hi,
Try this formula in B2, and copy down.
=LEFT(A2,LEN(A2)-1)*-1
You will have to format the cell to Number, 2 decimal places.
Regards - Dave.
Date: Tue, 4 Aug 2009 14:38:34 +0530
Subject: $$Excel-Macros$$ Formula-Replacing Minus Symbol
From: puttamada...@gmail.com
To:
THanks Dave, this is working fine for me..
Rgds- Putta
On Tue, Aug 4, 2009 at 5:09 PM, Dave Bonallack davebonall...@hotmail.comwrote:
Hi,
Try this formula in B2, and copy down.
=LEFT(A2,LEN(A2)-1)*-1
You will have to format the cell to Number, 2 decimal places.
Regards - Dave.
Hello,
You can use the following formual to achieve the required:
=-MID(B26,1,FIND(-,B26)-1)
The formula will add a - sign infront of the number extracted from original
value cell with suffixed - omitted.
Kind regards.
Serghei.
Date: Tue, 4 Aug 2009 14:38:34
Hi Puttam,
Same can be done with ASAP Utilities.
Text--Reverse text in selceted cell.
Hope this will saolve ur problem.
Rgds,
Mahender Bisht
On Tue, Aug 4, 2009 at 2:38 PM, Putta Madaiah puttamada...@gmail.comwrote:
Hi All,
Can any one tell me the formula to get the value as in Required
Hi Putta,
Try -
= substitute([cell ref],-,)*(-1)
Thanks
Alvin
On Aug 4, 5:08 pm, Putta Madaiah puttamada...@gmail.com wrote:
Hi All,
Can any one tell me the formula to get the value as in Required answer as
against Original Value.
*Original Value*
*Required answer*
125756.95-
