Re: $$Excel-Macros$$ small query

[ashish koul]

*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 wrote:

> Dear Delin,
>
> Please see attached sheet with Excel and VBA solution both.
>
> On Mon, Dec 17, 2012 at 12:55 PM, DELIN FRANCIS wrote:
>
>>
>>   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 more details find the attached file
>>
>> thanking you all in advance
>>
>> regards
>>
>>
>> *Delin.F*
>>
>>  --
>> 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, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>  --
> 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, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ small query

[NOORAIN ANSARI]

Dear Delin,

Please see attached sheet with Excel and VBA solution both.

On Mon, Dec 17, 2012 at 12:55 PM, DELIN FRANCIS wrote:

>
>   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 more details find the attached file
>
> thanking you all in advance
>
> regards
>
>
> *Delin.F*
>
>  --
> 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, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Convert Number to Text(Excel and VBA Both).xlsm
Description: Binary data

Re: $$Excel-Macros$$ small query

[Amresh Maurya]

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) = " Billion ": Place(5) = " Trillion "
' String representation of amount.
MyNumber = Trim(Str(MyNumber))
' Position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, ".")
' Convert Paise and set MyNumber to Rupees amount.
If DecimalPlace > 0 Then
Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
myCrores = MyNumber \ 1000
myLakhs = (MyNumber - myCrores * 1000) \ 10
MyNumber = MyNumber - myCrores * 1000 - myLakhs * 10
Count = 1
Do While myCrores <> ""
Temp = GetHundreds(Right(myCrores, 3))
If Temp <> "" Then Crores = Temp & Place(Count) & Crores
If Len(myCrores) > 3 Then
myCrores = Left(myCrores, Len(myCrores) - 3)
Else
myCrores = ""
End If
Count = Count + 1
Loop
Count = 1
Do While myLakhs <> ""
Temp = GetHundreds(Right(myLakhs, 3))
If Temp <> "" Then Lakhs = Temp & Place(Count) & Lakhs
If Len(myLakhs) > 3 Then
myLakhs = Left(myLakhs, Len(myLakhs) - 3)
Else
myLakhs = ""
End If
Count = Count + 1
Loop
Count = 1
Do While MyNumber <> ""
Temp = GetHundreds(Right(MyNumber, 3))
If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees
If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = ""
End If
Count = Count + 1
Loop
Select Case Crores
Case "": Crores = ""
Case "One": Crores = " One Crore "
Case Else: Crores = Crores & " Crores "
End Select
Select Case Lakhs
Case "": Lakhs = ""
Case "One": Lakhs = " One Lakh "
Case Else: Lakhs = Lakhs & " Lakhs "
End Select
Select Case Rupees
Case "": Rupees = "Zero "
Case "One": Rupees = "One "
Case Else:


Rupees = Rupees
End Select
Select Case Paise
Case "": Paise = " Only "
Case "One": Paise = " Only "
Case Else: Paise = " Only "
End Select
SpellNumber = Crores & _
Lakhs & Rupees & IIf(incRupees, " Rupees ", "") & Paise
End Function
' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right("000" & MyNumber, 3)
' Convert the hundreds place.
If Mid(MyNumber, 1, 1) <> "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
' Convert the tens and ones place.
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & GetTens(Mid(MyNumber, 2))
Else
Result = Result & GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function
' Converts a number from 10 to 99 into text.
Function GetTens(TensText)
Dim Result As String
Result = "" ' Null out the temporary function value.
If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...
Select Case Val(TensText)
Case 10: Result = "Ten"
Case 11: Result = "Eleven"
Case 12: Result = "Twelve"
Case 13: Result = "Thirteen"
Case 14: Result = "Fourteen"
Case 15: Result = "Fifteen"
Case 16: Result = "Sixteen"
Case 17: Result = "Seventeen"
Case 18: Result = "Eighteen"
Case 19: Result = "Nineteen"
Case Else
End Select
Else ' If value between 20-99...
Select Case Val(Left(TensText, 1))
Case 2: Result = "Twenty "
Case 3: Result = "Thirty "
Case 4: Result = "Forty "
Case 5: Result = "Fifty "
Case 6: Result = "Sixty "
Case 7: Result = "Seventy "
Case 8: Result = "Eighty "
Case 9: Result = "Ninety "
Case Else
End Select
Result = Result & GetDigit _
(Right(TensText, 1)) ' Retrieve ones place.
End If
GetTens = Result
End Function
' Converts a number from 1 to 9 into text.
Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = "One"
Case 2: GetDigit = "Two"
Case 3: GetDigit = "Three"
Case 4: GetDigit = "Four"
Case 5: GetDigit = "Five"
Case 6: GetDigit = "Six"
Case 7: GetDigit = "Seven"
Case 8: GetDigit = "Eight"
Case 9: GetDigit = "Nine"
Case Else: GetDigit = ""
End Select
End Function
Sub createnewinvoice()
Worksheets("New Invoice").Activate
End Sub



"

On Mon, Dec 17, 2012 at 12:55 PM, DELIN FRANCIS  wrote:
>
>   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 more details find the attached file
>
> thanking you all in advance
>
> regards
>
>
> Delin.F
>
> --
> 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, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a work

Re: $$Excel-Macros$$ small query about conditional formating

[ashish koul]

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  wrote:

> Hi,
> Pls help me to solve a small query.
> i have mentioned the query 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, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Small Query

[DELIN FRANCIS]

 hi Kenil Gala,

find the attached file it will solve your prob

regards


 
 
Delin.F 
 



 From: Kenil Gala 
To: excel macros  
Sent: Monday, 26 November 2012 8:48 PM
Subject: $$Excel-Macros$$ Small Query
 

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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




doubt in excel.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Small Query

[Kenil Gala]

Thank you Sir!!

--- On Mon, 11/26/12, ashish koul  wrote:


From: ashish koul 
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 at 10:18 PM, Kenil Gala  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 concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 




-- 

Regards
 
Ashish Koul





Visit
http://www.excelvbamacros.com/
http://www.accessvbamacros.com/


P Before printing, think about the environment.

 

-- 
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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 

-- 
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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Small Query

[ashish koul]

 E4=  (7-WEEKDAY(D4,2))+D4



On Mon, Nov 26, 2012 at 10:18 PM, Kenil Gala  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 concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
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, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Small Query

[Shrinivas Shevde]

Dear Rajan
I dont have a word to express myself I dont want to say thanks again and
again.
Just salute to you

Regards
Shrinivas

On Sat, Sep 15, 2012 at 9:11 AM, Rajan_Verma wrote:

>  *Hi shrinivas,*
>
> * *
>
> *I have learned it from Microsoft page , link in mentioned below *
>
> * *
>
>
> http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-HP010342372.aspx
> 
>
> ** **
>
> *Another useful information you can find on chandoo.org*
>
> * *
>
>
> http://chandoo.org/wp/2008/02/25/custom-cell-formatting-in-excel-few-tips-tricks/
> **
>
> * *
>
> * *
>
> *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
>
>  ** **
>
> Dear Rajan
>
> Really thanks for reply and as said by Ayush nice explanation.
>
> Is there any article or material to read on custom format if yes please
> let me know.
>
>  
>
> Regards
>
> Shrinivas
>
> On Fri, Sep 14, 2012 at 10:37 PM, Ayush Jain 
> wrote:
>
> Good explaination Rajan
>
> cheers
>
> On Fri, Sep 14, 2012 at 7:43 PM, Rajan_Verma 
> wrote:
>
> *Sure,*
>
> * *
>
> *The Custom Format is divided into 4 segment ,delimited by a Semicolon
> (;) , that  4 segments are :-*
>
> * *
>
> *Positive ; Negative ; Zero ; Text*
>
> * *
>
> *So the corresponding values with the segment will display as format
> defined , here in this example I use :*
>
> * *
>
> *#,## ; -#,##; ;@*
>
> *Here*
>
> *First Segment will work for Positive value  ( Means positive value would
> be show as thousand separated)*
>
> *Second Segment will work for Negative value  ( Means Negative value
> would be show as thousand separated with a Minus (-) Sign.)*
>
> *Third Segment will work for Zero , you will notice that I did not give
> any format in Zero Segment (Means No Zero will display)*
>
> *In Last segment “@” sign display  a text like # display a number.*
>
> * *
>
> * *
>
> *Regards*****
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@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
>
> Shrinivas
>
>  
>
> On Thu, Sep 13, 2012 at 7:36 PM, Rajan_Verma 
> wrote:
>
> *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$$ 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 
> wrote:
>
> 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 
> wrote:
>
>  
>
> Hi,
>
>  
>
> Try This.
>
>  
>
> =IFERROR(IF(A1,"0",""),"")
>
> Regards, 
>
> Kuldeep Singh
>
>  
>
> On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde 
> wrote:
>
> 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 

RE: $$Excel-Macros$$ Small Query

[Rajan_Verma]

Hi shrinivas,

 

I have learned it from Microsoft page , link in mentioned below 

 

http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-H
P010342372.aspx

 

Another useful information you can find on chandoo.org

 

http://chandoo.org/wp/2008/02/25/custom-cell-formatting-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

 

Dear Rajan

Really thanks for reply and as said by Ayush nice explanation.

Is there any article or material to read on custom format if yes please let
me know.

 

Regards

Shrinivas

On Fri, Sep 14, 2012 at 10:37 PM, Ayush Jain  wrote:

Good explaination Rajan

cheers

On Fri, Sep 14, 2012 at 7:43 PM, Rajan_Verma 
wrote:

Sure,

 

The Custom Format is divided into 4 segment ,delimited by a Semicolon (;) ,
that  4 segments are :-

 

Positive ; Negative ; Zero ; Text

 

So the corresponding values with the segment will display as format defined
, here in this example I use :

 

#,## ; -#,##; ;@

Here

First Segment will work for Positive value  ( Means positive value would be
show as thousand separated)

Second Segment will work for Negative value  ( Means Negative value would be
show as thousand separated with a Minus (-) Sign.)

Third Segment will work for Zero , you will notice that I did not give any
format in Zero Segment (Means No Zero will display)

In Last segment "@" sign display  a text like # display a number.

 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@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

Shrinivas

 

On Thu, Sep 13, 2012 at 7:36 PM, Rajan_Verma 
wrote:

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$$ 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 
wrote:

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 
wrote:

 

Hi,

 

Try This.

 

=IFERROR(IF(A1,"0",""),"")

Regards, 

Kuldeep Singh

 

On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde 
wrote:

Dear All

 

If i enter 0(zero) in any cell.it <http://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 violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> .

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regardi

Re: $$Excel-Macros$$ Small Query

[Shrinivas Shevde]

Dear Rajan
Really thanks for reply and as said by Ayush nice explanation.
Is there any article or material to read on custom format if yes please let
me know.

Regards
Shrinivas

On Fri, Sep 14, 2012 at 10:37 PM, Ayush Jain  wrote:

> Good explaination Rajan
> cheers
>
>  On Fri, Sep 14, 2012 at 7:43 PM, Rajan_Verma wrote:
>
>>  *Sure,*
>>
>> * *
>>
>> *The Custom Format is divided into 4 segment ,delimited by a Semicolon
>> (;) , that  4 segments are :-*
>>
>> * *
>>
>> *Positive ; Negative ; Zero ; Text*
>>
>> * *
>>
>> *So the corresponding values with the segment will display as format
>> defined , here in this example I use :*
>>
>> * *
>>
>> *#,## ; -#,##; ;@*
>>
>> *Here*
>>
>> *First Segment will work for Positive value  ( Means positive value
>> would be show as thousand separated)*
>>
>> *Second Segment will work for Negative value  ( Means Negative value
>> would be show as thousand separated with a Minus (-) Sign.)*
>>
>> *Third Segment will work for Zero , you will notice that I did not give
>> any format in Zero Segment (Means No Zero will display)*
>>
>> *In Last segment “@” sign display  a text like # display a number.*
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@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
>>
>> Shrinivas
>>
>> ** **
>>
>> On Thu, Sep 13, 2012 at 7:36 PM, Rajan_Verma 
>> wrote:
>>
>> *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$$ 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 
>>
>> 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 
>> wrote:
>>
>>  
>>
>> Hi,
>>
>>  
>>
>> Try This.
>>
>>  
>>
>> =IFERROR(IF(A1,"0",""),"")
>>
>> Regards, 
>>
>> Kuldeep Singh
>>
>>  
>>
>> On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde <
>> shrinivas...@gmail.com> wrote:
>>
>> 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 violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don'

Re: $$Excel-Macros$$ Small Query

[Ayush Jain]

Good explaination Rajan
cheers

On Fri, Sep 14, 2012 at 7:43 PM, Rajan_Verma wrote:

>  *Sure,*
>
> * *
>
> *The Custom Format is divided into 4 segment ,delimited by a Semicolon
> (;) , that  4 segments are :-*
>
> * *
>
> *Positive ; Negative ; Zero ; Text*
>
> * *
>
> *So the corresponding values with the segment will display as format
> defined , here in this example I use :*
>
> * *
>
> *#,## ; -#,##; ;@*
>
> *Here*
>
> *First Segment will work for Positive value  ( Means positive value would
> be show as thousand separated)*
>
> *Second Segment will work for Negative value  ( Means Negative value
> would be show as thousand separated with a Minus (-) Sign.)*
>
> *Third Segment will work for Zero , you will notice that I did not give
> any format in Zero Segment (Means No Zero will display)*
>
> *In Last segment “@” sign display  a text like # display a number.*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@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
>
> Shrinivas
>
> ** **
>
> On Thu, Sep 13, 2012 at 7:36 PM, Rajan_Verma 
> wrote:
>
> *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$$ 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 
> wrote:
>
> 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 
> wrote:
>
>  
>
> Hi,
>
>  
>
> Try This.
>
>  
>
> =IFERROR(IF(A1,"0",""),"")
>
> Regards, 
>
> Kuldeep Singh
>
>  
>
> On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde 
> wrote:
>
> 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 violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thr

RE: $$Excel-Macros$$ Small Query

[Rajan_Verma]

Sure,

 

The Custom Format is divided into 4 segment ,delimited by a Semicolon (;) ,
that  4 segments are :-

 

Positive ; Negative ; Zero ; Text

 

So the corresponding values with the segment will display as format defined
, here in this example I use :

 

#,## ; -#,##; ;@

Here

First Segment will work for Positive value  ( Means positive value would be
show as thousand separated)

Second Segment will work for Negative value  ( Means Negative value would be
show as thousand separated with a Minus (-) Sign.)

Third Segment will work for Zero , you will notice that I did not give any
format in Zero Segment (Means No Zero will display)

In Last segment "@" sign display  a text like # display a number.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@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

Shrinivas

 

On Thu, Sep 13, 2012 at 7:36 PM, Rajan_Verma 
wrote:

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$$ 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 
wrote:

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 
wrote:

 

Hi,

 

Try This.

 

=IFERROR(IF(A1,"0",""),"")

Regards, 

Kuldeep Singh

 

On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde 
wrote:

Dear All

 

If i enter 0(zero) in any cell.it <http://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 violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> .

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> .
 
 




-- 
Shrini

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members alre

Re: $$Excel-Macros$$ Small Query

[Shrinivas Shevde]

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, Rajan_Verma wrote:

>  *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$$ 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 
> wrote:
>
> 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 
> wrote:
>
> ** **
>
> Hi,
>
> ** **
>
> Try This.
>
> ** **
>
> =IFERROR(IF(A1,"0",""),"")
>
> Regards, 
>
> Kuldeep Singh
>
> ** **
>
> On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde 
> wrote:
>
> 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 violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
>
>
>
> --
> Shrini
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of an

RE: $$Excel-Macros$$ Small Query

[Rajan_Verma]

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$$ 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 
wrote:

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 
wrote:

 

Hi,

 

Try This.

 

=IFERROR(IF(A1,"0",""),"")

Regards, 

Kuldeep Singh

 

On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde 
wrote:

Dear All

 

If i enter 0(zero) in any cell.it <http://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 violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> .

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> .
 
 




-- 
Shrini

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> .
 
 




-- 
With Regards,
Noorain Ansari
 <http://www.noorainansari.com> http://noorainansari.com
<http://www.noorainansari.com> 
 <http://www

Re: $$Excel-Macros$$ Small Query

[Shrinivas Shevde]

Dear Kuldeep/Noorani/David
Very very thanks for kind help

Regards
Shrinivas


On Thu, Sep 13, 2012 at 4:24 PM, David Grugeon  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 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 a new workbook and save it as Book.xlt as a template in the
> xlstart directory
>
> Regards
> David Grugeon
>
>
> On 13 September 2012 17:10, Shrinivas Shevde 
> wrote:
> > 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 violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > 6) Jobs posting is not allowed.
> >
> > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > To unsubscribe from this group, send email to
> > excel-macros+unsubscr...@googlegroups.com.
> >
> >
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 
Shrini

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Small Query

[David Grugeon]

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 a new workbook and save it as Book.xlt as a template in the
xlstart directory

Regards
David Grugeon


On 13 September 2012 17:10, Shrinivas Shevde  wrote:
> 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 violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Small Query

[Shrinivas Shevde]

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 wrote:

>
> Hi,
>
> Try This.
>
> =IFERROR(IF(A1,"0",""),"")
>
> Regards,
> Kuldeep Singh
>
> On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde  > wrote:
>
>> 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 violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Shrini

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Small Query

[Kuldeep Singh]

Hi,

Try This.

=IFERROR(IF(A1,"0",""),"")

Regards,
Kuldeep Singh

On Thu, Sep 13, 2012 at 12:40 PM, Shrinivas Shevde
wrote:

> 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 violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.