Can I enter dollar amount without the $ appearing on the left side of
the cell?
Thanks,
Ralphael, the OLD one
Can I enter dollar amount without the $ appearing on the left side of
the cell?
Thanks,
Ralphael, the OLD one
change the format
--
Don Guillett
SalesAid Software
[email protected]
"Ralphael1" <[email protected]> wrote in message
news:[email protected]...
> Can I enter dollar amount without the $ appearing on the left side of
> the cell?
> Thanks,
>
> Ralphael, the OLD one
>
Sure, just format the cells as Number or Currency rather than Accounting.
Gord Dibben Excel MVP
On 6 Oct 2005 14:45:56 -0700, "Ralphael1" <[email protected]> wrote:
>Can I enter dollar amount without the $ appearing on the left side of
>the cell?
>Thanks,
>
>Ralphael, the OLD one
Gord Dibben wrote:
> Sure, just format the cells as Number or Currency rather than Accounting.
>
All well and good up to a point...but....5.00 appears as just 5. the
zeros after the decimal are nowhere to be seen...
Ralphael, the OLD one
format>number>lets you select the decimals. Look again
--
Don Guillett
SalesAid Software
[email protected]
"Ralphael1" <[email protected]> wrote in message
news:[email protected]...
>
> Gord Dibben wrote:
> > Sure, just format the cells as Number or Currency rather than
Accounting.
> >
> All well and good up to a point...but....5.00 appears as just 5. the
> zeros after the decimal are nowhere to be seen...
>
> Ralphael, the OLD one
>
OK, Thanks, now I think I understand something that was palin as day I
should have seen.
Kudos'
Ralph
glad to help
--
Don Guillett
SalesAid Software
[email protected]
"Ralphael1" <[email protected]> wrote in message
news:[email protected]...
> OK, Thanks, now I think I understand something that was palin as day I
> should have seen.
>
> Kudos'
>
> Ralph
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks