Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom number format
Can a custom number format be created to format a value such as 9,999,999.25
to format 9 999 999,25? I know the # ### ### works to add spaces but I can't figure out the decimal and don't want to change regional setting. Thanks, Jake |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom number format
2007 ButtonExcel OptionsAdvancedEditing optionsUncheck Use System
Separators. Use comma for decimal point. Same in 2003 under ToolsOptionsInternational Gord Dibben MS Excel MVP On Tue, 4 May 2010 10:49:01 -0700, Jake wrote: Can a custom number format be created to format a value such as 9,999,999.25 to format 9 999 999,25? I know the # ### ### works to add spaces but I can't figure out the decimal and don't want to change regional setting. Thanks, Jake |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cell custom Number format | Excel Worksheet Functions | |||
convert number to % using only custom number format challenge | Excel Discussion (Misc queries) | |||
Custom number format for driver's license number | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions |