You could use a macro, or, you could use a formula by: 1. Copy the sheet to another sheet. 2. in Cell D7 use: =IF('P & L'!D7>0,'P & L'!D7 / 1000000,0) (If you want round it to even values, use: =IF('P & L'!D7>0,ROUND('P & L'!D7 / 1000000,0),0) 3. Copy this cell to all columns and rows 4. Select Copy-> Paste Special -> Values
if you'd prefer the macro, let me know. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Prathap <prathap....@gmail.com> To: excel-macros@googlegroups.com Sent: Thu, October 13, 2011 1:31:01 PM Subject: Re: $$Excel-Macros$$ Urgent Help required Thank you all for your assistance. However i have a sheet (containing 67 columns & 3980 rows) were i need to change the entire cell into million. Attached is the sample sheet Best Regards, PRATHAP D M +91 9899-370-328 On 13 October 2011 20:22, Prathap <prathap....@gmail.com> wrote: Hi, > >Is there a way to convert all the cells with numbers in to million format with >shortcut / formula. > >Example: 1232345487 i want as 1232. > > Attached is the sample file > >Best Regards, >PRATHAP D >M +91 9899-370-328 >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com/ >4. Learn VBA Macros at http://www.quickvba.blogspot.com/ >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/ > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel