Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2012, 02:20 AM
Metamag Metamag is offline Forced extra decimal places Windows 7 64bit Forced extra decimal places Office 2010 64bit
Novice
Forced extra decimal places
 
Join Date: Apr 2011
Posts: 23
Metamag is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
then in the custom formats list
Where is that, is it called "custom formats" or something else?
Reply With Quote
  #2  
Old 08-18-2012, 02:28 AM
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

In Home tab, at Number section, in the format drop down list, the last line is More number formats. Click on it, it will open the format window. On the Number tab, on the left side, the last entry in the list is Custom. Click on it, then in the right side you will see a list of custom format. You will find in that list the wrong formats that must be deleted... select the entry , and Under that list there is a Delete button.
Reply With Quote
  #3  
Old 08-18-2012, 03:05 AM
Metamag Metamag is offline Forced extra decimal places Windows 7 64bit Forced extra decimal places Office 2010 64bit
Novice
Forced extra decimal places
 
Join Date: Apr 2011
Posts: 23
Metamag is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
You will find in that list the wrong formats that must be deleted... select the entry , and Under that list there is a Delete button.
I just selected 0,00 type but it's OK now, it formats correctly under currency.

Anyway, thanks for the solution!

I misread what you were trying to say because having two different separators was counter-intuitive to me.
Reply With Quote
  #4  
Old 08-18-2012, 03:10 AM
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

Glad it's ok now.
You can mark your thread as solved, then..(top of the page, under thread tools-mark this thread as solved.)
Reply With Quote
Reply



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 06:06 AM.


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