Try by using as below
=if(iserror(formula),on error,formula)
Thanks and Regards,
Somnath C Pardeshi
Sent from BlackBerry® on Airtel
-Original Message-
From: chandra sekaran
Sender: excel-macros@googlegroups.com
Date: Mon, 27 Feb 2012 10:24:13
To:
Reply-To: excel-macros@googlegroups.c
Hi,
Try following steps in excel
Range a2
1 go to data then data validation
2 settings
3 allow custom
4 formula =countif($a$1:a1,a2)=o
5 copy this cell and paste down with validation
This will not allow you to reenter name
if you use formula =countif($a$1:a1,a2)<>0 in conditional formatting t
Hi
Try this
=if(and(a1c1),a1,0)
Thanks and Regards,
Somnath C Pardeshi
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-
From: RockyFontane
Sender: excel-macros@googlegroups.com
Date: Mon, 17 Oct 2011 08:08:40
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@go
Hi
In a cell type 100 copy it( ctrl + C)
Select all cells then paste special ( Alt + E + S + V + I ) value with divide
operation
This will convert all the numbers in million format.
Thanks and Regards,
Somnath C Pardeshi
+91 966 419 4782
Sent from my BlackBerry® Smartphone on Loop Mobile.
Hi
Just divide this by 100
Try this formula =A1/10^6
Thanks and Regards,
Somnath C Pardeshi
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-
From: Prathap
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 20:22:52
To:
Reply-To: excel-macros@googl
Hi
Try this
In a excel file select any area
Then start recording macro ( alt + t + m + r ) save macro in personal file
Insure that you will not change selection before stop the macro recording
Assign border to selection as per your req.
Stop recording macro
Press alt + f8
Select recorded macro
Go
Hi
Try this
=text(A2,"000")
This will convert in text with format as per your req.
If you want same value in number then change the format with to custom 000
Thanks and regards,
Somnath C Pardeshi
+91 829 111 9311
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-