Rodney

Posts: n/a

rounding.

G'day Trendsetters,
I seek to round up numbers and part numbers
to 800, with the round up result showing a three digit read out.
eg: 1 as 001, 56 as 056, 750 as 750.
any legerdemain available?

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
Unwanted rounding of large number	Candyman	Excel Worksheet Functions	5	August 18th 05 12:32 AM
Rounding numbers to the nearest 5 or 0	Fieldmedic	Excel Worksheet Functions	3	July 17th 05 06:51 AM
Rounding	LaraHubbs	Excel Discussion (Misc queries)	2	June 21st 05 09:42 PM
Percentage rounding error in charts	Tracey	Excel Discussion (Misc queries)	4	May 14th 05 04:01 AM
Banker's Rounding - need help!	Somecallmejosh	Excel Discussion (Misc queries)	3	January 20th 05 09:53 PM

All times are GMT +1. The time now is 10:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us