Excel default number format problem "Jason" <Nosaj4[ at ]gmail.com> 24.07.2006 15:08:04 I have a user with an incorrect default cell format in Excel. His default number of decimal places for a cell with numbers is set to 4 instead of 2. I have no idea how he caused this and I have no idea how to correct it. In case I'm being ambiguous, here is the procedure: Open a new Excel workbook, choose any cell and go to Format. In the Format Cell dialog box go to the Number tab and choose the Number category. The Decimal Places box will be set to 2 by default but in this user's Excel it is set to 4. How do I get it back to the default of 2? http://www.imagedump.com/index.cgi?pick=get&tp=439712 http://i110.photobucket.com/albums/n111/nosaj19/gthompsonexcel.jpg

Re: Excel default number format problem "DL" <address[ at ]invalid> 24.07.2006 16:12:31 You might have crossposted to an Excel group, rather than multiposting here This Q was posted some month or so ago, try a google group search "Jason" <Nosaj4[ at ]gmail.com> wrote in message news:1153753684.853244.216820[ at ]h48g2000cwc.googlegroups.com... [Quoted Text] > I have a user with an incorrect default cell format in Excel. His > default number of decimal places for a cell with numbers is set to 4 > instead of 2. I have no idea how he caused this and I have no idea how > to correct it. In case I'm being ambiguous, here is the procedure: > Open a new Excel workbook, choose any cell and go to Format. In the > Format Cell dialog box go to the Number tab and choose the Number > category. The Decimal Places box will be set to 2 by default but in > this user's Excel it is set to 4. How do I get it back to the default > of 2? > > http://www.imagedump.com/index.cgi?pick=get&tp=439712 > http://i110.photobucket.com/albums/n111/nosaj19/gthompsonexcel.jpg >

Re: Excel default number format problem "Jason" <Nosaj4[ at ]gmail.com> 24.07.2006 16:19:22 I didn't know how to crosspost. The original from a month ago was me but I couldn't go back to add screenshots so I created the post again. DL wrote: [Quoted Text] > You might have crossposted to an Excel group, rather than multiposting here > This Q was posted some month or so ago, try a google group search

Re: Excel default number format problem "DL" <address[ at ]invalid> 24.07.2006 18:14:51 You crosspost the same way as you address an email to multiple addresses i.e. Enter each newsgroup addresse separated by a semicolon "Jason" <Nosaj4[ at ]gmail.com> wrote in message news:1153757962.269847.270180[ at ]h48g2000cwc.googlegroups.com... [Quoted Text] > I didn't know how to crosspost. The original from a month ago was me > but I couldn't go back to add screenshots so I created the post again. > DL wrote: > > You might have crossposted to an Excel group, rather than multiposting here > > This Q was posted some month or so ago, try a google group search >