--- 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
<*> 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/
