Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 10 million appears as 10,000,000.00

how to change thousand seprator in excel 2003 and 10 million appears as
10,00,000.00
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 10 million appears as 10,000,000.00


[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00

will format say 1234567890 as 123,45,67,890.00

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ravi" <ravi @discussions.microsoft.com wrote in message
...
how to change thousand seprator in excel 2003 and 10 million appears as
10,00,000.00



Reply
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
cell selection appears locked. How do I unlock it. Heinz Excel Worksheet Functions 1 August 30th 06 08:24 PM
how many times a particular day of the week appears in a given month CheapTequila Excel Discussion (Misc queries) 4 August 8th 06 12:07 PM
how do i count the number of times criteria appears in a worksheet MarkWatson Excel Worksheet Functions 2 August 1st 06 07:09 AM
Highlight if Data entered appears in another workbook mg_sv_r Excel Worksheet Functions 0 May 23rd 06 03:40 PM
How to count the number of times a string appears in a column? btsray Excel Worksheet Functions 0 January 25th 06 10:15 PM


All times are GMT +1. The time now is 12:50 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"