LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
davey888
 
Posts: n/a
Default Custom formats to round numbers such as 16,465,123 to 16,500,000

Can you please provide a custom format that will format (for example)
16,465,123 to the nearest 100,000 (16,500,000)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Cell will not format numbers correctly for a 13 digit custom barc. Laudan Excel Worksheet Functions 4 April 11th 05 08:13 PM
How to format text and numbers as custom Julian Ganoudis Excel Discussion (Misc queries) 4 April 4th 05 06:55 PM
How do I make custom formats with superscript or subscript%3f eagle Excel Worksheet Functions 3 December 28th 04 08:48 PM
Custom Formats becky Excel Discussion (Misc queries) 6 December 24th 04 01:24 AM
Custom Formats Stan Altshuller Excel Worksheet Functions 1 December 13th 04 09:47 PM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"