Trim numbers to x decimal places

Posted to microsoft.public.excel.programming

Andrea[_8_] Andrea[_8_] is offline

external usenet poster

Posts: 5

Trim numbers to x decimal places

Help please !!!!

I am trying to write some code that will trim general
numbers.

e.g. 123.123456789 to 123.1234

I have looked at Trim Statements but these only seem to
apply to characters and spacing.

Thanks Andrea

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
enter numbers without decimal places	wt.pm	Excel Discussion (Misc queries)	3	July 30th 09 06:33 PM
Why do my numbers keep going down decimal places?	Excell2002ishard	Setting up and Configuration of Excel	2	March 27th 08 09:36 PM
Why do my numbers keep going down decimal places?	Excell2002ishard	Setting up and Configuration of Excel	2	March 27th 08 08:09 PM
Sum of numbers with only two decimal places wrong	Excelgonecrazy	Excel Discussion (Misc queries)	2	November 13th 07 07:21 PM
Subtracting two 2-decimal place numbers gives result 13-decimal places?	[email protected]	Excel Worksheet Functions	5	March 12th 07 10:38 PM

All times are GMT +1. The time now is 05:34 PM.

Menu

About Us