*With formula* http://web.pdx.edu/~wde/Code/Excel_Files/No_VBA_Spellout.php
VBA http://www.contextures.com/excelfilesRon.html#RF0001
http://support.microsoft.com/kb/213360
On Mon, Dec 17, 2012 at 1:20 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Delin,
Please see
Hi,
Kindly use this function code .
Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
Dim Crores, Lakhs, Rupees, Paise, Temp
Dim DecimalPlace As Long, Count As Long
Dim myLakhs, myCrores
ReDim Place(9) As String
Place(2) = Thousand : Place(3) = Million
Place(4) =
Dear Delin,
Please see attached sheet with Excel and VBA solution both.
On Mon, Dec 17, 2012 at 12:55 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote:
HI friends...
A small query in excel is there any way to convert numbers in to words
eg :-
1202 = One Thousand two hundred and Two
for
try these first
http://www.youtube.com/watch?v=LOaezdoyJDE
http://www.techrepublic.com/blog/10things/10-cool-ways-to-use-excels-conditional-formatting-feature/3166
http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html
On Wed, Nov 28, 2012 at 10:33 PM, Kenil Gala keni...@yahoo.com wrote:
hi Kenil Gala,
find the attached file it will solve your prob
regards
Delin.F
From: Kenil Gala keni...@yahoo.com
To: excel macros excel-macros@googlegroups.com
Sent: Monday, 26 November 2012 8:48 PM
Subject: $$Excel-Macros$$ Small Query
Hi,
Pls
Hi,
Pls help me solve my small doubt.
I have written it in the file attached.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
E4= (7-WEEKDAY(D4,2))+D4
On Mon, Nov 26, 2012 at 10:18 PM, Kenil Gala keni...@yahoo.com wrote:
Hi,
Pls help me solve my small doubt.
I have written it in the file attached.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Thank you Sir!!
--- On Mon, 11/26/12, ashish koul koul.ash...@gmail.com wrote:
From: ashish koul koul.ash...@gmail.com
Subject: Re: $$Excel-Macros$$ Small Query
To: excel-macros@googlegroups.com
Date: Monday, November 26, 2012, 4:57 PM
E4= (7-WEEKDAY(D4,2))+D4
On Mon, Nov 26, 2012
@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: 14 September 2012 9:24
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Small Query
Dear Rajan
Very very thanks for reply.
Can u make me understand meaning of (#,##;-#,##;;@ )
this will be helpful for me i future
Regards
@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Small Query
** **
Dear Rajan
Very very thanks for reply.
Can u make me understand meaning of (*#,##;-#,##;;@ )*
*this will be helpful for me i future*
Regards
Shrinivas
** **
On Thu, Sep 13, 2012 at 7:36 PM
2012 2:13
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Small Query
Dear Shrinivas,
See attached sheet, Column No. A, hope it will help to you.
On Thu, Sep 13, 2012 at 12:47 PM, Shrinivas Shevde
shrinivas...@gmail.com wrote:
Dear Kuldeep
-in-excel-few-tips-tr
icks/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: 15 September 2012 9:08
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Small Query
*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
*Sent:* 15 September 2012 9:08
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Small Query
** **
Dear Rajan
Dear All
If i enter 0(zero) in any cell.it should show blank cell.
It should not show the zero.
lease let me know how to do it
Thanks in advance
--
Shrini
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Hi,
Try This.
=IFERROR(IF(A1,0,),)
Regards,
Kuldeep Singh
On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde
shrinivas...@gmail.comwrote:
Dear All
If i enter 0(zero) in any cell.it should show blank cell.
It should not show the zero.
lease let me know how to do it
Thanks in advance
--
Dear Kuldeep
Thanks for reply but where do I use this formula .
can u attached file and show it to me.
If I enter 0 in A1 then it should not take it should show cell blank
Thanks
Regards
Shrinivas
On Thu, Sep 13, 2012 at 12:43 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
Try This.
File/Options/Advanced/Display options for this worksheet
untick Show a zero in cells that have a zero value
This will only work on the active sheet. If you want it to apply to
the whole workbook select all sheets first.
If you want it to apply to new workbooks you create you will need to
modify
Dear Kuldeep/Noorani/David
Very very thanks for kind help
Regards
Shrinivas
On Thu, Sep 13, 2012 at 4:24 PM, David Grugeon da...@grugeon.com.au wrote:
File/Options/Advanced/Display options for this worksheet
untick Show a zero in cells that have a zero value
This will only work on the
Why Don't try Custom format
#,##;-#,##;;@
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 13 September 2012 2:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
*
*#,##;-#,##;;@*
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* 13 September 2012 2:13
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Small Query
20 matches
Mail list logo
