Number formatting

[Guest]

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

 

[Jason Morin]

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