Posted to microsoft.public.excel.programming

Chang

external usenet poster

Posts: 1

truncating and rounding

Hello,

When truncating and rounding figures, how do I get excel
to display any significant 0's in the final result

Many thanks
Chang

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
Truncating a VIN	lputnam	Excel Discussion (Misc queries)	3	November 11th 09 05:28 PM
text truncating	Overcome by info	Excel Discussion (Misc queries)	2	October 1st 07 04:16 PM
numbers truncating	Sue	Excel Discussion (Misc queries)	3	January 25th 07 12:52 PM
truncating text	scott_cairns	Excel Discussion (Misc queries)	7	May 30th 06 01:51 PM
Truncating numbers	Susana C via OfficeKB.com	Excel Worksheet Functions	1	May 8th 06 04:42 PM

All times are GMT +1. The time now is 12:32 PM.

About Us

"It's about Microsoft Excel"