Posted to microsoft.public.excel.worksheet.functions

Tricia

external usenet poster

Posts: 17

Decimal places

I am trying to display less decimal places without the figure being rounded,
eg 29.37500 to display only 29.37. Can anyone help me with this please?

--
Tricia

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
decimal places	narp[_2_]	Excel Discussion (Misc queries)	2	May 14th 08 09:39 PM
Subtracting two 2-decimal place numbers gives result 13-decimal places?	[email protected]	Excel Worksheet Functions	5	March 12th 07 10:38 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.	SUKYKITTY	Excel Discussion (Misc queries)	3	July 6th 05 01:50 PM
decimal places	Simon0009	Excel Discussion (Misc queries)	2	June 3rd 05 06:20 PM
add 2 decimal places	Bill M.	Excel Discussion (Misc queries)	2	January 28th 05 10:21 PM

All times are GMT +1. The time now is 08:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us