• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to copy the Number formula until the last cell of excel

K

Kumar@raja

Member
Dear Friends,

Kindly guide me how to copy the number format which is mentioned in cell A 1 to A 1048576 in a single stroke in attached file? I have copied the format from A 1 to A 366 and I would like to copy the same until the last cell which is mentioned above. As you know for doing the same will consume good amount of time. Hence, please let me know if we can do the same in a simple manner.

Your kind support in this regard is highly appreciated.

Thanks in advance,
Kumar
 

Attachments

Select entire column and press Ctrl+Shift+1, it will change the format of entire column in number format with 2 decimal.
PS : And also to get the series which you have entered 1,1.01,1.02. Press Alt => e => i =>s then type .01 in step value and press enter.

Regards,
 
Last edited:
You must log in or register to reply here.
Back
Top