Re: $$Excel-Macros$$ US$ currency Format

2014-07-18 Thread Paul Schreiner
can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Rohan Young >To: excel-macros@googlegroups.com >Sent: Friday, July 18, 2014 5:02 AM >Subject: $$Excel-Macros$$ US$ curre

Re: $$Excel-Macros$$ US$ currency Format

2014-07-18 Thread Vaibhav Joshi
If it doesn't work then you need to change your regional settings of Windows!! Goto Control panel, Select Regional & Language, in format Tab select Additional settings, Select currency tab, goto digital grouping & select second option from top with coma after 3rd digit. Cheers!! On Fri, Jul 1

Re: $$Excel-Macros$$ US$ currency Format

2014-07-18 Thread XLS S
try below [>=1000]$ ##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 . Enjoy Team XLS On Fri, Jul 18, 2014 at 2:32 PM, Rohan Young wrote: > *Hi Experts* > > * how do get US$ currency format from 1234567 to 1,234,567* > > thanks > > -- > Are you =EXP(E:RT) or =NOT(EX

$$Excel-Macros$$ US$ currency Format

2014-07-18 Thread Rohan Young
*Hi Experts* * how do get US$ currency format from 1234567 to 1,234,567* thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, ac