Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells (number) issue
Hi, ok this is my problem... All my numbers in workbook look like this now: (for example) 1.234.567 or (1.234.567) when negative - meaning one million two hundred thirty four five hundred sixty seven. To get that number I had to format cells by entering: #.##0;(#.##) Now I need to format my numbers to look like 1,234.567 (a comma instead of a dot behind a million digit). How can I do that, please help. Thx in advance, Amalthea -- Amalthea ------------------------------------------------------------------------ Amalthea's Profile: http://www.excelforum.com/member.php...o&userid=33168 View this thread: http://www.excelforum.com/showthread...hreadid=529915 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells (number) issue
Create a custom format using the following input mask:
#,###.##0;(#,###.##0) -- Kevin Backmann "Amalthea" wrote: Hi, ok this is my problem... All my numbers in workbook look like this now: (for example) 1.234.567 or (1.234.567) when negative - meaning one million two hundred thirty four five hundred sixty seven. To get that number I had to format cells by entering: #.##0;(#.##) Now I need to format my numbers to look like 1,234.567 (a comma instead of a dot behind a million digit). How can I do that, please help. Thx in advance, Amalthea -- Amalthea ------------------------------------------------------------------------ Amalthea's Profile: http://www.excelforum.com/member.php...o&userid=33168 View this thread: http://www.excelforum.com/showthread...hreadid=529915 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |