I think, u need to format the cell in Number Format. Pls make decimal place
as 0. U should
get the result.
Paul
On Wed, May 13, 2009 at 7:26 PM, larry wrote:
>
> I am talking about the format cells command. If you select a cell or
> cells and right click you will see a format cell option. Selec
do u want to average where coresponding cell is " marked as "yes"?
Paul
On Wed, May 13, 2009 at 5:05 PM, Damian wrote:
>
> Hi Andy
>
> thank you for reply & sorry for small delay...
>
> I have range of data C1:E10 and A1:A10 each cell got drop down list
> with values: "Yes" and "No". for exampl
Hi Sharma,
First you have to format all the necessary cells as 'Text', otherwise the "0"
is lost.
Then try putting this into data validation (Custom, Formula) of A3:
=AND(ISNUMBER(VALUE(A3)),LEN(A3)=10,LEFT(A3,1)="0")
Copy validation to necessary cells.
Hope this helps.
Regards - Dave
D
I work with Excel spreadsheets that are imported from another database
application.
After importing the data into Excel I run 3 separate macros to format
and sort the data that I want to keep and work with.
Currently I run the three macros one at a time because I do not know
how to define a variab
hi all newbie here, need some help
so i have a list of file names in cells
i.e.
b4 "aaa01"
b5 "bbb02"
b6 "ccc09"
.
.
.
how can i loop thur those cells, get there values and do a search on a
local computer folder?
i.e.
c:\from files
then copy files inside the foler ( i dont need zzz000
Thank you in advance. I searched many sites and threads. I am most
likely missing something very easy but I am just lost at this point.
I have en Excel file that contains a "save" button. The button will
help the user execute an auto save to a folder along with a file name
(based on the invoic
Hey Rakesh,
Thanks It Works,
Thanks
Regards,
Jitendra
On Wed, May 13, 2009 at 7:38 PM, Rakesh Sharma wrote:
>
> Hi
>
> You can try this.
>
> Column A Column B Column C
> 5/13/2009 19:33 ABC =CONCATENATE(TEXT(A1,"m/d/ hh:mm:ss am/pm"),"
> ",B1)
>
> Result would be
Its a smart trick and a quick solution too.
m i correct Dilip Sir.
On Tue, May 12, 2009 at 9:25 PM, zheng yu wrote:
> hahahaha...Ctrl+H again..hehe ,well it comes in handy:-)
>
> On Tue, May 12, 2009 at 4:54 PM, Dilip Pandey wrote:
>
>> Hi
>>
>> press Ctrl +H and replace "total charge:" with "".
You could use the following piece of code:
With Cell(1,1).Characters(Start:=6, Length:=3).Font
.FontStyle = "Bold"
.Color = -16776961
End With
Where Start is the first character position of the word you want to change,
and Length is the word length.
If you have some trouble with t
Hi Damian,
You can attach the worksheet with the reply email.. or directly send at
aind...@gmail.com
Regards,
Andy
On Wed, May 13, 2009 at 6:35 PM, Damian wrote:
>
> Hi Andy
>
> thank you for reply & sorry for small delay...
>
> I have range of data C1:E10 and A1:A10 each cell got drop down li
Hi
You can try this.
Column A Column B Column C
5/13/2009 19:33 ABC =CONCATENATE(TEXT(A1,"m/d/ hh:mm:ss am/pm"),"
",B1)
Result would be : 5/13/2009 07:33:00 PM ABC
Regards
Rakesh
On May 12, 12:57 pm, jamadagnira...@gmail.com wrote:
> Hello,
>
> I have a proble
I am talking about the format cells command. If you select a cell or
cells and right click you will see a format cell option. Select text
and your problem may be solved.
On May 12, 10:29 am, "2008ra...@gmail.com" <2008ra...@gmail.com>
wrote:
> i was try the cell text format.but that value is chan
Hi,
following problem is causing me sleepless nights:
I have got a table containing a list of patents. I would like to
search for specific terms/words in the abstracts of the patents and to
mark them by changing their color. I do not want to change the color
of the whole cell containing the speci
Hi Harmeet,
I have attached one sample workbook that contains a query for data
validation.
I just need a macro for the same.
Thanks for your help.
Regards,
Sharma
On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote:
> Hi,
>
> Please see attached file.
>
> On Wed, May 6, 2009 at 5:53 PM, am
Hi,
Please find the attached workbook with the solution. Consider the Cell A1
and watch the Conditional Formatting logics.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, May 6, 2009 at 5:04 PM,
Any guy here tried to build a COM or .NET library for EXCEL?
Some calculation takes huge amount of time in VBA, so i am thinking using
C++ or C# to do the calculation and VBA just calls this add-in class to do
the job and get the result .
On Thu, May 7, 2009 at 6:42 PM, Ajit Navre wrote:
>
>
Yogendra,
To get back the original file there is a Software already installed in the
Office - just go to - Programs- Microsoft office - Microsoft office tools -
Microsoft application recovery tools then wait & see
On Wed, May 13, 2009 at 12:23 PM, Yogendra Joshi wrote:
> Dear All,
>
> I am get
Hi Andy
thank you for reply & sorry for small delay...
I have range of data C1:E10 and A1:A10 each cell got drop down list
with values: "Yes" and "No". for example i change values in A1, A4 and
A7 to "No" and i don't want the corresponding rows C1:E1, C4:E4 and
C7:E7 were taken into average calc
Hi Harmeet,
Please find the attached sample workbook that contains a simple query for my
project.
Thanx in advance.
Regards,
Sharma
On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote:
> Hi,
>
> Please see attached file.
>
> On Wed, May 6, 2009 at 5:53 PM, amrahs k wrote:
>
>> Hi Team,
>>
Dear,
Use the following formatting options with either concatenate or "&"
=concatenate(TEXT(A1,"DD/MM/ h:mm:ss AM/PM"), " ",B1)
Or
=TEXT(A1,"DD/MM/ h:mm:ss AM/PM")& " "&B1
CA_logo_icai Small1
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba
20 matches
Mail list logo
