Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal separators in formulas
I have a VBA application in Excel that puts formulas in various cells. For
example, I need cells that look like this: =IF(D4=0,0,D3/D4) This is pretty simple. But in some cases, I need to put an actual number from a variable. For example, I have this line of code: ...Cells(A1).Value = "=IF(RC[+3]=0,0," & nMyVar & "/RC[+3])" If nMyVar = 5, then I get this in cell A1: =IF(D4=0,0,5/D4) And if nMyVar = 5.5, I get this in cell A1: =IF(D4=0,0,5.5/D4) Again, this is pretty simple.. but for a little thing. Our application runs on PCs which have different regional settings for the decimal separator. So for those who use a comma (,) as a separator, the formula becomes: =IF(D4=0,0,5,5/D4) As you can see, the number of 'commas' in there will mess up the formula. When I use RecordMacro to do it manually, it will record it with a period (.) instead of a comma. But then if I program this, it won't work. Also, the RecordMacro will use semi-colon (; as the IF(;;) separator... (that's what it says in Excel's help file).. But again it won't work... My Excel will only accept commas for the IF (,,) separator. Any ideas anyone???? Thanks Somatophylax |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Points and comma separators | Excel Discussion (Misc queries) | |||
Urgent - make formula work with both decimal separators | Excel Discussion (Misc queries) | |||
Can I insert a row that has no column separators? | Excel Discussion (Misc queries) | |||
I need separators on the X axis of a chart. | Charts and Charting in Excel | |||
how to remove separators from numbers | Excel Discussion (Misc queries) |