> *From:* pawel lupinski
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Sunday, April 1, 2012 10:45 PM
> *Subject:* Re: $$Excel-Macros$$ Re: format a cell
>
> HI ALL
>
> in first words I'd like to thanks you all ever so much for so many
> replies. Its
ul solution.
Again thanks a lot.
Pawel
From: Haseeb A
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Sunday, April 1, 2012 7:42 PM
Subject: $$Excel-Macros$$ Re: format a cell
Hello Pawel,
Another one.
=TEXT(A1*IF(ISNUMBER(FIND(".",A1)),100,1),"
thanks a lot.
Pawel
From: Haseeb A
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Sunday, April 1, 2012 7:42 PM
Subject: $$Excel-Macros$$ Re: format a cell
Hello Pawel,
Another one.
=TEXT(A1*IF(ISNUMBER(FIND(".",A1)),100,1),"00\:00")
If you want
Hello Pawel,
Another one.
=TEXT(A1*IF(ISNUMBER(FIND(".",A1)),100,1),"00\:00")
If you want to enter 2 for 2'O clock enter as 200 or cell format as text
then enter like 2.00
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titl
