Re: $$Excel-Macros$$ Truncate after 16 digits

2011-11-17 Thread Skanda
> > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Skanda > *Sent:* Wednesday, November 16, 2011 9:41 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Truncate after 16 digits > > **

RE: $$Excel-Macros$$ Truncate after 16 digits

2011-11-16 Thread Asa Rossoff
$$ Truncate after 16 digits There are values like this:-3.89811069564618E-07 How to truncate after 16 digits after the decimal? -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

$$Excel-Macros$$ Truncate after 16 digits

2011-11-16 Thread Skanda
There are values like this:-3.89811069564618E-07 How to truncate after 16 digits after the decimal? -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Nee