Posted to microsoft.public.excel.programming

Nils Titley Nils Titley is offline

external usenet poster

Posts: 84

Formating problem

I am using the following

Now
A) Format((BeatMetersTotal(MyNum) / BinTotal(MyNum)), "0.0")
Previously
B) Format((BeatMetersTotal(MyNum) / BinTotal(MyNum)), "0.00")

I want my output to show one decimal place. I get the following with the
above format: A) 2 B) 1.98. How do I force it so I get what I want. I am
using the same data to generate the same report.

Thanks

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
Conditional formating problem	excelent	Excel Discussion (Misc queries)	3	September 24th 09 02:15 PM
Formating Problem	Dave	Excel Discussion (Misc queries)	1	January 28th 08 01:02 PM
Conditional Formating Problem	MESTRELLA29	Excel Discussion (Misc queries)	6	October 13th 06 11:31 PM
formating problem, PLEASE help.	guy12345	Excel Discussion (Misc queries)	5	August 31st 06 05:50 PM
Chart formating problem	KrunoG	Charts and Charting in Excel	0	February 10th 06 08:38 PM

All times are GMT +1. The time now is 08:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us