Can you send me an example?
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eileenh7 Sent: Monday, May 02, 2005 11:53 AM To: [email protected] Subject: [ms_access] Re: Exporting to Excel get "$ before numbers --- In [email protected], "Travis R. Simons" <[EMAIL PROTECTED]> wrote: > select the column that has the currency, then click format, click > cells.., select currency in the number tab. I hope this helps. Travis, I have tried numerous types of reformatting of these cells using the format function -- but it ignors anything I select. For instance, in your recommendation, I should be able to tell it to not use the $ -- I select None -- but the $ still remains. Eileen > > On 4/29/05, eileenh7 <[EMAIL PROTECTED]> wrote: > > I have received a file that is exported to Excel. My problem is that > > the currency field has "$ in front of the number. In Excel when I try > > to do an edit/replace of the "$, Excel says it cannot find it. > > > > Thanks in advance for your help > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > -- > Travis Simons > 512.388.5808 Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
