Posted to microsoft.public.excel.worksheet.functions

Tarfun

external usenet poster

Posts: 4

Custom Formatting

What is the custom format to display numbers to the nearest 100 or nearest
10, i.e., 721 be displyed as 700 or 720. I know that formattig a number that
way will retain its unrounded value in memory for all computations performed
using it. (Not so using the "Round" Function.)
--
Leo

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
Custom Formatting	cliff	New Users to Excel	2	April 18th 08 06:17 PM
custom formatting	BorisS	Excel Discussion (Misc queries)	0	March 17th 08 06:16 PM
expanding custom formatting without removing existing cell formatting?	Keith	Excel Worksheet Functions	3	December 27th 06 01:54 PM
Custom formatting	John Knoke	Excel Discussion (Misc queries)	3	March 26th 05 04:25 PM
custom formatting	Lara Shook	Setting up and Configuration of Excel	1	February 16th 05 03:30 AM

All times are GMT +1. The time now is 09:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us