Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
How do I format a number to show in thousands with comma seperator. For
example I would like to show 1050040 as 1,050. Thanks for your assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
IN EXCEL 2007 take the following action:-
Highlight the cell(s) you wnat to change - right hand click and select Format Cells (window of same name should launch) - Number tab - click in the box called:- Use 1000 Separator (,) Hit OK If my comments have helped please hit Yes. Thanks. "Jamal" wrote: How do I format a number to show in thousands with comma seperator. For example I would like to show 1050040 as 1,050. Thanks for your assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
sorry, within the Number tab, select Number on the left hand side then:-
- click in the box called:- Use 1000 Separator (,) Apologies for error. "trip_to_tokyo" wrote: IN EXCEL 2007 take the following action:- Highlight the cell(s) you wnat to change - right hand click and select Format Cells (window of same name should launch) - Number tab - click in the box called:- Use 1000 Separator (,) Hit OK If my comments have helped please hit Yes. Thanks. "Jamal" wrote: How do I format a number to show in thousands with comma seperator. For example I would like to show 1050040 as 1,050. Thanks for your assistance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
Thanks for the answer. Unfortunately I am using Excel 2003. Thanks.
"trip_to_tokyo" wrote: sorry, within the Number tab, select Number on the left hand side then:- - click in the box called:- Use 1000 Separator (,) Apologies for error. "trip_to_tokyo" wrote: IN EXCEL 2007 take the following action:- Highlight the cell(s) you wnat to change - right hand click and select Format Cells (window of same name should launch) - Number tab - click in the box called:- Use 1000 Separator (,) Hit OK If my comments have helped please hit Yes. Thanks. "Jamal" wrote: How do I format a number to show in thousands with comma seperator. For example I would like to show 1050040 as 1,050. Thanks for your assistance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
Hi Jamal - it should still be more or less the same.
Just get to the Format Cells command / Number tab / then Number on the left hand side. I don't think it changed much between the 2 version. Please hit Yes if my comments have helped. "Jamal" wrote: Thanks for the answer. Unfortunately I am using Excel 2003. Thanks. "trip_to_tokyo" wrote: sorry, within the Number tab, select Number on the left hand side then:- - click in the box called:- Use 1000 Separator (,) Apologies for error. "trip_to_tokyo" wrote: IN EXCEL 2007 take the following action:- Highlight the cell(s) you wnat to change - right hand click and select Format Cells (window of same name should launch) - Number tab - click in the box called:- Use 1000 Separator (,) Hit OK If my comments have helped please hit Yes. Thanks. "Jamal" wrote: How do I format a number to show in thousands with comma seperator. For example I would like to show 1050040 as 1,050. Thanks for your assistance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
Hi you are right that the thousand seperator is there. However, the probelm
is if you have use the thousand seperator in the number format then a seven digit number such as 1000000 is shown as 1,000,000. What I am looking for is to just show 1,000 (in thousands, I could get it by 1,000,000/1000 = 1,000). But wanted to find out if there is a custom format that will do the trick. If you use the custom format of #,; then it shows 1000 and loses the comma. I can't figure out how to show long numbers in thousands or even millions and still have the comma. Thanks for your help. "trip_to_tokyo" wrote: Hi Jamal - it should still be more or less the same. Just get to the Format Cells command / Number tab / then Number on the left hand side. I don't think it changed much between the 2 version. Please hit Yes if my comments have helped. "Jamal" wrote: Thanks for the answer. Unfortunately I am using Excel 2003. Thanks. "trip_to_tokyo" wrote: sorry, within the Number tab, select Number on the left hand side then:- - click in the box called:- Use 1000 Separator (,) Apologies for error. "trip_to_tokyo" wrote: IN EXCEL 2007 take the following action:- Highlight the cell(s) you wnat to change - right hand click and select Format Cells (window of same name should launch) - Number tab - click in the box called:- Use 1000 Separator (,) Hit OK If my comments have helped please hit Yes. Thanks. "Jamal" wrote: How do I format a number to show in thousands with comma seperator. For example I would like to show 1050040 as 1,050. Thanks for your assistance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format
If I understood - you want to display "Millions" as "Thousand".
If so - Custom Format those cells as: #,##0, Micky "Jamal" wrote: How do I format a number to show in thousands with comma seperator. For example I would like to show 1050040 as 1,050. Thanks for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |