But it's not a formula in the cell.
Blank cell
code loops through sees if it has a "-" and if it doesn't it moves to
the next.
If it does, the data in that cell is 18 digits before the removal of
the "-", and 17 after.
The code does not modify the cell at all if there is no "-"
--
-
Hi,
Try below code;
Function Spell(ByVal MyNumber)
' Last updated 03-Oct-2003
' SpellIndian (modified on 20-Sep-2003 to 1) show Rupees to
precede, and to show "" for 0 paise)
' ySpellRupees (on 20-Nov-2002)
' Excel UDF to spell Indian Currency -- Rupees and Pai
Hi Kumar
Can you send sample file. you can crate copy of sheet1 3 times but the
sheet name will not be "sheet1"
On Sat, Mar 20, 2010 at 5:09 PM, C.G.Kumar wrote:
> Thanks Mahesh,
>
> It really worked ... But i would appreciate if the following minor
> modification is possible..
>
> I want to ad
Thanks Mahesh,
It really worked ... But i would appreciate if the following minor
modification is possible..
I want to add "SHEET 1 "(a sheet in the same workbook/excel file) 3 TIMES
since count of the column is 3 .
Regards,
Kumar
On Sat, Mar 20, 2010 at 1:51 PM, Mahesh parab wrote:
> Hi
Hi,
Kindly specify your requirements for automating the reports.
Regards
Yogananda.Muthaiah
Ph : 9731237267
On 3/19/10, Shilpa Rao wrote:
> Hi,
>
> Do we have any tools to automate financial reports?
>
>
>
> --
> Regards,
> Shilpa
>
> --
> --
Hi Kevin
Module 1 & 2 for sending emails from excel sheet, u can read further on this
link http://www.rondebruin.nl/sendmail.htm , code in sheet 1 to sort your
data when u enter
email id in column B.
On Sat, Mar 20, 2010 at 12:24 AM, KevinM wrote:
> Mahesh: Why do I need code in module 1 and
experts plz help its urgent...
regards,
simran
On Fri, Mar 19, 2010 at 11:52 PM, Simran Singh wrote:
> Hello experts,
>
> I am preparing a tracker attached with this mail. What i have done so far
> is that in the first sheet "Summary" user when double click on the cell
> containing name of
Hi,
If you have a formula in a cell, it is never considered blank, even if the
formula returns an apparent blank.
You will often get this with 'IF' formulas: eg IF(A20=5,"Bing","")
If A20 does not equal 5, then the formula returns a "".
But XL sees this as a zero-length string, not a blank ce
