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

Computing desk
< May 28 << Apr | May | Jun >> May 30 >
Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.


May 29

edit

MS Excel 2007: Comma-Delimited Formatting Button Behaves Strangely

edit

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)[reply]

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. Dbfirs 15:26, 31 May 2014 (UTC)[reply]