 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / January 2006thousand separator
I require to format my excel sheet using Indian system of formatting number to use thousand separators which is like ##,##,##,##0.00 and not as ###,###,##0.00. I have already changed the regional settings in Windows Contol Panel suitably and checked the suitable option in Excel/Tools/Options to select thousand separator as per system settings. Still my number are formatted as ###,###,##0.00 Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00 A Google search is a good place to start with questions. The first entry in a search of Microsoft.public.excel.* groups for "Indian comma" looks promising http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/ 83c821267c245de5/8dbf439d68bbad02?hl=en#8dbf439d68bbad02 Jerry > I require to format my excel sheet using Indian system of formatting number > to use thousand separators which is like ##,##,##,##0.00 and not as [quoted text clipped - 7 lines] > > Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00 Use a custom format of [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00  SignatureHTH RP (remove nothere from the email address if mailing direct) > I require to format my excel sheet using Indian system of formatting number > to use thousand separators which is like ##,##,##,##0.00 and not as [quoted text clipped - 7 lines] > > Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00 Jerry, The link does not solve the problem as I am using Excel 2003 under Windows XP Professional. This version of windows provides for Indian Commas Style, which I have selected in the Windows Regional Settings. The point is that Excel is not using this setting. Is it a bug? Should Excel not be using the thousand separators as defined under Regional Settings in Windows? Or am I missing something. > I require to format my excel sheet using Indian system of formatting number > to use thousand separators which is like ##,##,##,##0.00 and not as [quoted text clipped - 7 lines] > > Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00 Did you try the custom format from my link, which Bob Phillips reproduced in this thread? It works fine for me in Excel 2003. The trick is to use "\," instead of just "," in the custom format. Jerry > Jerry, > The link does not solve the problem as I am using Excel 2003 under Windows [quoted text clipped - 16 lines] > > > > Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00 Jerry, While I agree that the custom format described by you work, the point here is why is excel not picking up the format from the system settings. Excel 2003 is supposed to this. Right? > Did you try the custom format from my link, which Bob Phillips reproduced in > this thread? It works fine for me in Excel 2003. The trick is to use "\," [quoted text clipped - 22 lines] > > > > > > Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.