Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Undesired Rounding in VBA; accumulating values

On Sun, 25 Jan 2004 14:30:43 -0500, "Tom Ogilvy" wrote:

? ActiveCell.NumberFormat
$#,##0.00
? typename(activecell.Value)
Currency

Aha! That's why Value2 works differently than Value in this instance.

Thanks for the info.

--ron

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
On exit from edit, Excel jumps to remote undesired cell.	[email protected]	Excel Discussion (Misc queries)	2	July 21st 08 12:15 PM
Undesired links: Pasting from one excel document to another	ProS	Links and Linking in Excel	1	December 30th 07 08:35 PM
Rounding up values	Sarah (OGI)	Excel Worksheet Functions	1	September 20th 07 11:17 AM
accumulating values generated daily	Tracey	Excel Worksheet Functions	1	April 15th 06 08:07 AM
Accumulating Values in a Pivot table	Kurt	Excel Discussion (Misc queries)	2	March 2nd 05 08:42 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us