Wikipedia:Reference desk/Archives/Computing/2014 May 29

= May 29 =

MS Excel 2007: Comma-Delimited Formatting Button Behaves Strangely
In MS Excel 2007, when I click the comma "," formatting button on the Ribbon, it usually formats cells as comma-delimited numbers (e.g. 1,000.00). However, on a few occasions it will format cells as percentages (e.g. 100000%) or not format them at all (e.g. 1000 stays 1000). Standard workarounds like copying the data to a new worksheet don't fix the problem, although typing the number in again by hand does. This isn't a big problem (just annoying), but I wondered if anyone else had experienced this or had any idea what causes it. Thanks! OldTimeNESter (talk) 12:15, 29 May 2014 (UTC)


 * I have an earlier version of Excel, and I've tried to replicate your problem because I thought it might be connected with the previous format of the cell, but the button in my version seems to work even if the cell was previously formatted as text.   D b f i r s   15:26, 31 May 2014 (UTC)