Hi All,
can anybody help me out to solving this problem into excel.
I want to display following item automatically through condition or
formulla.
1.10.2.30
1.10.2.40
and so on
Regards
Abdul Hakim Khan
KSA
Al Jubail
abdulhakimk...@gmail.com
ignore my previous message and use the format as below:
Select the column and go to menu Format Cells Numbers Custom and put
this as format 0.00.0.00 and say ok
now when you type 110230 will convert 1.10.2.30, then in cell below put
formula +a1+10 and drag it down upto where u want...
hope
Hi Abdul,
Is there a fixed number of lines you want to cover?
Or does this depend on data of some other cell?
Regards,
Andy
On Mon, Mar 16, 2009 at 5:10 PM, Abdul Hakim Khan
abdulhakimk...@gmail.comwrote:
Hi All,
can anybody help me out to solving this problem into excel.
I want to display
if it is ok...
Select the column and go to menu Format Cells Numbers Custom and put
this as format 0-00-0-00 and say ok
now when you type 110230 will convert 1-10-2-30, then in cell below put
formula +a1+10 and drag it down upto where u want...
hope this helps.
On Mon, Mar 16, 2009 at 1:10
RESPECTED SIR,
MYSELF RAHUL KUAMR SUREKA. I M CURRENTLY USING MS-OFFICE
2007.SO,PLEASE TELL ME HOW TO USE THE FUNCTION OF MICRO AND MACRO IN
EXCEL.PLEASE TELL ME THAT IS THERE IS ANY DOWNLOAD SITE FROM WHERE I CAN
DOWNLOAD SOME USEFUL TIPS REGARDING EXCEL.,THEN PLEASE MENTION
You can format the cell to display the number as 1.10.2.30.
Format-Cells-Number-Custom
Type in the format as 0\.00\.0\.00
Now, the underlying value of the cells will continue to be 110230 (a
number), but will be displayed as 1.10.2.30, you can then suitably increment
or decrement
Hi,
I am struggling to link my macro to a different workbook from which i
need the data.
Basically, my requirement is like this:
There are two different workbooks with say five worksheets each. Now
what i want to do is use informations form i th worksheets in
workbook2 into ith worksheet in
Just thought of sharing this function with the group. I created it to elaminate
lengthy match index formula from my reports
_
There are known knowns. These are things we know that we know. There are