LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default Excel 2002 : How to set thousand separator at tool bar ?

Dear Sir,

The numeric format ( Comma Sign ) at my tool bar is a number with two
decimal places without a thousand separator.

May I know how change the default of this icon to two decimal places with a
thousand separator (e.g. 12,145.26) ?

Also when I go to Format Cells Numbers , the thousand separator box always
uncheck, can I change this default to always check ?


Thanks

Low


--
A36B58K641
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
thousand separator Antonio Excel Discussion (Misc queries) 1 April 4th 08 03:07 AM
Ctrl+Shift+! for two decmial places with thousand separator Ken NX Excel Discussion (Misc queries) 2 June 4th 07 03:17 AM
thousand separator conversion from dot to comma Spike Excel Discussion (Misc queries) 10 January 31st 06 09:07 PM
thousand separator R Kapoor Setting up and Configuration of Excel 5 January 5th 06 10:32 AM
thousand separator as indian style for negative number kamlakar Excel Discussion (Misc queries) 0 July 11th 05 12:23 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"