Just change custom formatting --
Select data range
right click
go to format cell
go to customer in number tab
paste this - dd/mm/
[image: Inline image 1]
On Mon, Jul 11, 2016 at 10:54 AM, Izhar wrote:
> Please open the file, I've given everything in the attach file
>
Hi,
I need help urgently
how to copy value from an object (i have copy objects from web page)
Thanks in advance
--
Regards,
Santy
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Hi,
can u please share some example sheet.
On Tue, Jun 18, 2013 at 9:25 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Dear expert,
I have a spreadsheet where every month I need to delete more than 500 rows
manually. Is there any macros automatically data should get
Exactly Priti you are right but your formula is not working ... as i
observe that you are just want increase your post count ..
in we will provide top best solution not a temporary solution
I totally agree with sunny...
On Wed, May 8, 2013 at 11:26 AM, priti verma
Hi maksood,
you can use series function with column selection..and in step value put 7
and Stop value put end date
[image: Inline image 1]
On Tue, May 7, 2013 at 6:05 PM, maksood alam 786maks...@gmail.com wrote:
Hi guys,
I have to select two dates, start date and end date. e.g. start date
You can also you use formula
like =SUBSTITUTE(E2,,,)
On Tue, May 7, 2013 at 1:30 PM, Ahmed Honest ahmedhon...@gmail.com wrote:
Hi Danial :
Press Ctrl + H and then
in find what box keep comma , and in replace leave it empty and click
Replace All it shall help...
On Tue, May 7,
Hi Amar,
If you are using Database function ..please ensure that all header name are
same i.e.. database,field, and criteria...
Your formula is working fine.. but you have changed header name see cell H11
Regard,
Santy
On Wed, Apr 24, 2013 at 3:29 PM, अनिल नारायण गवली
congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS
S),Noorain..
On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
July'11
He has posted 170 posts in July 2011
use formula
=IF(iserror(ur formula),,ur formula))
On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
I have one questions.Usually while doing reports what are errors you will
get ?
Thanks
--
congratulation ayush
On Tue, Jul 26, 2011 at 9:22 AM, Ayush jainayus...@gmail.com wrote:
Dear members,
I am glad to share that this forum has achieved two major milestones this
month. The number of members have reached 8000 and 1000 posts in a month
which is highest in forum history.
The
*Experience required for the Job:* 2 - 4 years
*Annual Salary of the Job:* 2.0 - 3.0 Lacs
*Job Location:* Delhi/NCR
*Dear Candidate,*
Hi,
We have an urgent requirement of MIS/Sr MIS Executive at our head office at
Okhla.
Company profile: CPM India is leading organization in sales marketing
Hey Boss,
Congratulation.
On Sun, Jul 3, 2011 at 8:15 PM, ashish koul koul.ash...@gmail.com wrote:
Thank You All..
On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal
brajeshkumarpor...@gmail.com wrote:
*Congratulations Ashish
Hey,
try my attachment
i think my formula is very simple so please try
Regards,
Santy C
On Mon, Jul 4, 2011 at 10:13 PM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello,
If you want to count the unique numbres in a range, use this with just
Enter,
Hey,
please provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's
how to use and instruction
--
Regards,
Santy C
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
MS Excel Expert (Macro / VBA)
2 Opening(s)
Shanti Consultants
*
*
Summary
*Experience:*
3 - 6 Years
*Location:*
Delhi, Delhi/NCR, Noida
*Compensation:*
Rupees 3,00,000 - 6,00,000
*Education:*
UG - B.Sc - Computers,BCA - Computers PG - PG Diploma - Computers
*Industry Type:*
Oil
15 matches
Mail list logo