Anyone know wht format string I would need to Change $100,000.00 to 100 000,00 $
C Chris Jan 27, 2009 #1 Anyone know wht format string I would need to Change $100,000.00 to 100 000,00 $
C Clifford Bass Jan 27, 2009 #2 Hi Chris, Usually you would use the Control Panel's Regional and Language Options to do that. Am I to take it that that is not an option due to certain reasons? A possible solution, at least for reports might be this: Replace(Replace(Format(100000.00, "#,##0.00 $"), ",", " "), ".", ",") Clifford Bass
Hi Chris, Usually you would use the Control Panel's Regional and Language Options to do that. Am I to take it that that is not an option due to certain reasons? A possible solution, at least for reports might be this: Replace(Replace(Format(100000.00, "#,##0.00 $"), ",", " "), ".", ",") Clifford Bass
H hor vannara Jan 27, 2009 #3 Chris said: Anyone know wht format string I would need to Change $100,000.00 to 100 000,00 $ Click to expand...
Chris said: Anyone know wht format string I would need to Change $100,000.00 to 100 000,00 $ Click to expand...
