Number formatting

Can anyone tell me how to enter 25 and have it appear in
the cell as 25,000,000? I have only been able to get it
to go out to 25,000 (using a custom fomatting string) but
after that it starts to bring the 25 to the end (ie
25,000,025).

Thanks in advance

1. Press Ctrl+1
2. Number Tab
3. Custom
4. Insert this to the right:
#",000,000"

This'll work for 1-99.

HTH
Jason
Atlanta, GA

-----Original Message-----
Can anyone tell me how to enter 25 and have it appear in
the cell as 25,000,000? I have only been able to get it
to go out to 25,000 (using a custom fomatting string) but
after that it starts to bring the 25 to the end (ie
25,000,025).

Thanks in advance
.

Hi
use the custom format

#,,.00


--
Regards
Frank Kabel
Frankfurt, Germany


Ket wrote:
Hello,

A simple question I'm sure. If I have monetary amounts in a
spreadsheet for example 1,970,000, how can I automatically show the
figure as 1.97?

Many thanks.

Ket

PS Using Excel/Windows 2000