| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of the comma in formatting numbers - Excel 2007
If I attempt to format a cell containing the number 1000000000 so that a
comma separates the thousands I get 1000000,000 instead of 1,000,000,000. How do I get 1,000,000,000? -- Creator |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use of the comma in formatting numbers - Excel 2007
Format Cells, Number, Number, tick "Use thousands separator"
Creator wrote: If I attempt to format a cell containing the number 1000000000 so that a comma separates the thousands I get 1000000,000 instead of 1,000,000,000. How do I get 1,000,000,000? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use of the comma in formatting numbers - Excel 2007
Thanks for the response Bob I. However That's what I've done but I get this
unexpected format. Here's what I mean.... I start with 1000000000 when I select the options as you have said I get 1000000,000 and not 1,000,000,000 That's basically the problem. -- Creator "Bob I" wrote: Format Cells, Number, Number, tick "Use thousands separator" Creator wrote: If I attempt to format a cell containing the number 1000000000 so that a comma separates the thousands I get 1000000,000 instead of 1,000,000,000. How do I get 1,000,000,000? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use of the comma in formatting numbers - Excel 2007
Are you sure your numbers are not text?
Go to a blank cell, format it as #,##0 then type in 1000000000 If I do that I get 1,000,000,000 however if the value is text and it comes with the last comma no numerical formats can change it -- Regards, Peo Sjoblom "Creator" wrote in message ... Thanks for the response Bob I. However That's what I've done but I get this unexpected format. Here's what I mean.... I start with 1000000000 when I select the options as you have said I get 1000000,000 and not 1,000,000,000 That's basically the problem. -- Creator "Bob I" wrote: Format Cells, Number, Number, tick "Use thousands separator" Creator wrote: If I attempt to format a cell containing the number 1000000000 so that a comma separates the thousands I get 1000000,000 instead of 1,000,000,000. How do I get 1,000,000,000? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use of the comma in formatting numbers - Excel 2007
Interesting, is your region in Windows set to US?
Creator wrote: Thanks for the response Bob I. However That's what I've done but I get this unexpected format. Here's what I mean.... I start with 1000000000 when I select the options as you have said I get 1000000,000 and not 1,000,000,000 That's basically the problem. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use of the comma in formatting numbers - Excel 2007
Hello Peo, thanks for your input.
I'm absolutely sure that the numbers aren't text. I'd have to admit it's a bit of a strange (and annoying) problem.If I open the file with an earlier version of Excel (e.g. 2003) I have no problem. -- Creator "Peo Sjoblom" wrote: Are you sure your numbers are not text? Go to a blank cell, format it as #,##0 then type in 1000000000 If I do that I get 1,000,000,000 however if the value is text and it comes with the last comma no numerical formats can change it -- Regards, Peo Sjoblom "Creator" wrote in message ... Thanks for the response Bob I. However That's what I've done but I get this unexpected format. Here's what I mean.... I start with 1000000000 when I select the options as you have said I get 1000000,000 and not 1,000,000,000 That's basically the problem. -- Creator "Bob I" wrote: Format Cells, Number, Number, tick "Use thousands separator" Creator wrote: If I attempt to format a cell containing the number 1000000000 so that a comma separates the thousands I get 1000000,000 instead of 1,000,000,000. How do I get 1,000,000,000? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use of the comma in formatting numbers - Excel 2007
Thanks Bob I. That's it.
Strange though. The region was set to English (Trinidad); by the way that's where I'm located. I changed it to English (US) AND IT WORKED. But in Trinidad though we don't format numbers that way. Thanks again! -- Creator "Bob I" wrote: Interesting, is your region in Windows set to US? Creator wrote: Thanks for the response Bob I. However That's what I've done but I get this unexpected format. Here's what I mean.... I start with 1000000000 when I select the options as you have said I get 1000000,000 and not 1,000,000,000 That's basically the problem. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use of the comma in formatting numbers - Excel 2007
Sorry, I don't know about Trinidad formatting, but if you get what you
need you're welcome, and have a great day! Creator wrote: Thanks Bob I. That's it. Strange though. The region was set to English (Trinidad); by the way that's where I'm located. I changed it to English (US) AND IT WORKED. But in Trinidad though we don't format numbers that way. Thanks again! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
| how to combine numbers with the comma | Excel Worksheet Functions | |||
| Indian comma in excel in positive numbers as well as in negative | Excel Discussion (Misc queries) | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| comma align numbers | Excel Discussion (Misc queries) | |||
Linear Mode
