RE: $$Excel-Macros$$ format a cell

2012-04-02 Thread Mohammed Muneer
# \ : ## Dear Rajan use this, Regards, Muneer, CC... -- FORUM RULES (986+ 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 att

RE: $$Excel-Macros$$ format a cell

2012-04-02 Thread Rajan_Verma
It's a custom format for 532 to covert in 5:32 Please try #":"## Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: Mar/Tue/2012 07:36 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ format a cell Hi All,

Re: $$Excel-Macros$$ format a cell

2012-04-01 Thread Maries
ation, and forcing people to do tis in right >>> way. But I need to sort past data and I'd like to learn from you all things >>> that I won't find in the books. >>> >>> Regards, >>> >>> Pawel >>> >>> PS macro I'm sti

Re: $$Excel-Macros$$ format a cell

2012-04-01 Thread Aamir Shahzad
hi Don, >> >> Yes, I've used data validation, and forcing people to do tis in right >> way. But I need to sort past data and I'd like to learn from you all things >> that I won't find in the books. >> >> Regards, >> >> Pawel >> >>

Re: $$Excel-Macros$$ format a cell

2012-04-01 Thread Maries
; PS macro I'm still not there. > > *From:* dguillett1 > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, March 29, 2012 1:51 PM > > *Subject:* Re: $$Excel-Macros$$ format a cell > > BTW. You could use data validation to guide them to ONLY input as > de

Re: $$Excel-Macros$$ format a cell

2012-03-29 Thread pawel lupinski
From: dguillett1 To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 1:51 PM Subject: Re: $$Excel-Macros$$ format a cell BTW. You could use data validation to guide them to ONLY input as desired. Or, an input box macro. Don Guillett Microsoft MVP Excel SalesAid Software dguill

Re: $$Excel-Macros$$ format a cell

2012-03-29 Thread dguillett1
quot;),""),2),RIGHT(TEXT(SUBSTITUTE(A1&0,".",""),""),2),0),TIME(LEFT(TEXT(SUBSTITUTE(A1,".",""),""),2),RIGHT(TEXT(SUBSTITUTE(A1,".",""),""),2),0))) But if you can have a look and simpl

Re: $$Excel-Macros$$ format a cell

2012-03-29 Thread pawel lupinski
t;),2),RIGHT(TEXT(SUBSTITUTE(A1&0,".",""),""),2),0),TIME(LEFT(TEXT(SUBSTITUTE(A1,".",""),""),2),RIGHT(TEXT(SUBSTITUTE(A1,".",""),"0000"),2),0)))   But if you can have a look and simplified it will be

Re: $$Excel-Macros$$ format a cell

2012-03-29 Thread Maries
HMAN PRASAD wrote: > Dear All, > > If my input is 1215 or 12.15 converted to 12:15 of 12:15 > > > > > > *From:* Aamir Shahzad > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, March 29, 2012 12:22 AM > > *Subject:* Re: $$Excel-Macros$$ format a

Re: $$Excel-Macros$$ format a cell

2012-03-28 Thread LAKSHMAN PRASAD
Dear All,   If my input is 1215 or 12.15 converted to 12:15 of 12:15         From: Aamir Shahzad To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 12:22 AM Subject: Re: $$Excel-Macros$$ format a cell Now see the attached file.  Aamir Shahzad

Re: $$Excel-Macros$$ format a cell

2012-03-28 Thread dguillett1
what about Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, March 28, 2012 3:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ format a cell Hi All, thanks a lot for everyone, special to Aamir yes this

Re: $$Excel-Macros$$ format a cell

2012-03-28 Thread pawel lupinski
: Wednesday, March 28, 2012 7:55 AM > >Subject: Re: $$Excel-Macros$$ format a cell > > > >Dear Pawel. > >Please try it.. > >=TIME(LEFT(C4,1),RIGHT(C4,2),0) > >-- > >Thanks & regards, >Noorain Ansari >http://noorainansari.com/ >http://excelmacrow

Re: $$Excel-Macros$$ format a cell

2012-03-28 Thread Aamir Shahzad
* Wednesday, March 28, 2012 7:55 AM > > *Subject:* Re: $$Excel-Macros$$ format a cell > > Dear Pawel. > > Please try it.. > > =TIME(LEFT(C4,1),RIGHT(C4,2),0) > > -- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacrow

Re: $$Excel-Macros$$ format a cell

2012-03-27 Thread LAKSHMAN PRASAD
Dear Noorain,   I think he want 532, and I'd like to be converted to 05:32      From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Wednesday, March 28, 2012 7:55 AM Subject: Re: $$Excel-Macros$$ format a cell Dear Pawel. Please try it..

Re: $$Excel-Macros$$ format a cell

2012-03-27 Thread NOORAIN ANSARI
Dear Pawel. Please try it.. =TIME(LEFT(C4,1),RIGHT(C4,2),0) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski wrote: > Hi All, > > I need your help on

Re: $$Excel-Macros$$ format a cell

2012-03-27 Thread dguillett1
May be useful to test LEN of cell (1051) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Tuesday, March 27, 2012 1:30 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ format a cell See if attached sheet is useful by formula

Re: $$Excel-Macros$$ format a cell

2012-03-27 Thread Aamir Shahzad
See if attached sheet is useful by formula Aamir Shahzad On Tue, Mar 27, 2012 at 7:05 PM, pawel lupinski wrote: > Hi All, > > I need your help on this simple task i don't know how to do this and for > you it will be easy. > > I'd like to input eg 532, and I'd like to be converted to 05:32 or