Posted to microsoft.public.excel.programming

external usenet poster

Posts: 69

Decimal problem

In a VBA project I'm supporting, I ran into a line where a cell is assigned the value

"=RC[4] / (" + Format(100 - dblNewProdSaving) + " / 100)"

I get a run-time error on this line. However, if I manually change the cell from where dblNewProdSaving is taken, from 0,02 to 0.02, it runs. Why is this and what can I do about it?

Gustaf

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Decimal problem	Gustaf	Excel Programming	16	June 3rd 09 10:54 PM
Formula problem with decimal	Gator	Excel Worksheet Functions	2	August 29th 08 07:59 PM
Problem with decimal format	Richard RE	Excel Worksheet Functions	2	June 22nd 06 05:49 PM
Decimal problem	Mats Samson	Excel Programming	3	February 20th 06 04:36 PM
Decimal translation problem	Francis Hayes (The Excel Addict)	Excel Discussion (Misc queries)	1	January 21st 05 02:15 PM

All times are GMT +1. The time now is 09:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us