software

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: www.excelforum.com/member.php...oamp;userid=33168
View this thread: www.excelforum.com/showthread...hreadid=529915Create a custom format using the following input mask:

#,###.##0;(#,###.##0)

--
Kevin Backmannquot;Amaltheaquot; wrote:

gt;
gt; Hi,
gt;
gt; ok this is my problem...
gt;
gt; All my numbers in workbook look like this now: (for example) 1.234.567
gt; or (1.234.567) when negative - meaning one million two hundred thirty
gt; four five hundred sixty seven.
gt; To get that number I had to format cells by entering: #.##0;(#.##)
gt;
gt; Now I need to format my numbers to look like 1,234.567 (a comma instead
gt; of a dot behind a million digit). How can I do that, please help.
gt;
gt; Thx in advance,
gt;
gt; Amalthea
gt;
gt;
gt; --
gt; Amalthea
gt; ------------------------------------------------------------------------
gt; Amalthea's Profile: www.excelforum.com/member.php...oamp;userid=33168
gt; View this thread: www.excelforum.com/showthread...hreadid=529915
gt;
gt;