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
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
Problem With Decimal Point	sifuconman	Excel Programming	2	August 3rd 06 02:11 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
problem with decimal in calculation	Amanda	Excel Discussion (Misc queries)	5	January 12th 06 05:25 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 03:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us