Posted to microsoft.public.excel.programming

MAS

external usenet poster

Posts: 18

Rounding up decimals

Hi,

I have a msgbox that displays the result of some work , for example as
28.58333

How do i get the result to display just 2 decimal places, ie 28.58

M

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
Rounding up decimals	Darren	Excel Worksheet Functions	2	May 25th 09 01:39 AM
Rounding decimals up or down	Friedbrain	Excel Discussion (Misc queries)	3	August 11th 08 02:19 PM
Rounding Up Decimals	Lilbit	Excel Worksheet Functions	8	January 4th 06 08:42 PM
Rounding Decimals	Jim May	Excel Discussion (Misc queries)	8	November 7th 05 06:02 PM
Rounding Decimals	Sho	Excel Worksheet Functions	6	November 16th 04 02:29 PM

All times are GMT +1. The time now is 04:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us