#6
|
|||
|
|||
I guess you changed only the decimal separator to "," and the thousands separator is now the same with the decimal separator, which is not a bug, is a mistake. If you use "," as a decimal separator, and "." as thousands separator, in formatting the cell select 2 decimal places and check the option "Use 1000 separator (.)" , the entry 1441,75 will be displayed as 1.441,75.
If you keep "," as decimal AND thousands separator, AND you check the option "Use 1000 separator (,)" (notice that the option now has comma in the paranthesis), excel is confused, will consider that your entry is an integer with no decimals, because of using the comma as the 1000 AND (!!) decimals separator , thats why it shows ",00" to display the decimals...... As for switching between columns, there is no such concept in excel, as far as i know. Use VBA or do it manually. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
extra space before equation | Nice2007 | Word | 1 | 04-27-2012 05:05 PM |
Mail Merge, Number to 2 Decimal Places | Vampy99 | Mail Merge | 7 | 09-25-2011 05:41 AM |
Extra fields - table of contents | saslotteroy | Word | 4 | 09-15-2011 01:23 AM |
Slight extra space between lines. | lucadelcarlo | Word | 1 | 04-23-2011 04:05 PM |
My Places | lukewarmbeer | Office | 0 | 07-13-2010 02:33 PM |