Posted to microsoft.public.excel.worksheet.functions

Ray88

Posts: n/a

Custom format rounding

How can I display 123,432,000 as 123,400 using custom formats? What I need is
rounding to the nearest 100,000.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to create your own custom format?	Scott Steiner	Excel Discussion (Misc queries)	5	November 22nd 05 05:46 PM
Custom number format button	Ken G.	Excel Discussion (Misc queries)	4	November 17th 05 05:59 AM
Custom Format to divide by 10	Ailish	Excel Discussion (Misc queries)	2	October 26th 05 05:04 PM
Custom Number Format...	whitmore0112	Excel Worksheet Functions	2	January 25th 05 10:11 PM
Custom Format and Data Validation Q	John	Excel Worksheet Functions	1	January 6th 05 05:56 PM

All times are GMT +1. The time now is 11:41 PM.

About Us

"It's about Microsoft Excel"