Posted to microsoft.public.excel.misc

Steve Holbrook Steve Holbrook is offline

external usenet poster

Posts: 1

only show decimals

I have a need to only show the figure to the right of a decimal point not the
whole number. Reason is to calculate the best bar length to use i.e. the
decimal bit is the size of the offcut and I need to find the optimum size.

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
How do I show only the whole number w/o eliminating four decimals?	kell~0	Excel Worksheet Functions	21	March 6th 07 05:35 PM
no decimals	BorisS	Excel Discussion (Misc queries)	1	September 18th 06 07:48 AM
decimals only.	joepose	Excel Discussion (Misc queries)	5	September 7th 06 01:05 PM
How to only show decimals if there are any	Myerse	Excel Discussion (Misc queries)	3	June 24th 06 08:40 PM
Rounding Decimals	Sho	Excel Worksheet Functions	6	November 16th 04 02:29 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us