Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 08-17-2012, 10:34 PM
Catalin.B Catalin.B is offline Forced extra decimal places Windows Vista Forced extra decimal places Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
extra space before equation Nice2007 Word 1 04-27-2012 05:05 PM
Forced extra decimal places 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
Forced extra decimal places 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft