How do I enter a negative dollar amount?

In Excel, I get an error message when trying to enter a negative dollar
amount. "You must enter a dollar amount in this cell." How do I enter a
negative amount without the error message and still have it add up correctly
at the ending column?

Sounds like somebody has set up Data validation on those cells, and either
you are trying to do something you shouldn't, or the person that built the
sheet didn't foresee all potential entries. Talk to whoever created the
sheet.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"CML" <CML@discussions.microsoft.com> wrote in message
news:93593703-E68D-48B8-AD54-E9F6F7201CF4@microsoft.com...
> In Excel, I get an error message when trying to enter a negative dollar
> amount. "You must enter a dollar amount in this cell." How do I enter a
> negative amount without the error message and still have it add up
correctly
> at the ending column?

Select one of the cells with the error message, and then:
<Data> <Validation>,
And see if you get the validation window with a formula, which you can
change.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"CML" <CML@discussions.microsoft.com> wrote in message
news:93593703-E68D-48B8-AD54-E9F6F7201CF4@microsoft.com...
> In Excel, I get an error message when trying to enter a negative dollar
> amount. "You must enter a dollar amount in this cell." How do I enter a
> negative amount without the error message and still have it add up
correctly
> at the ending column?

>> which you can change.

Or find out why it was there in the first place and if there was valid
reason that negative values were prohibited :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:OgmikvJDFHA.464@TK2MSFTNGP15.phx.gbl...
> Select one of the cells with the error message, and then:
> <Data> <Validation>,
> And see if you get the validation window with a formula, which you can
> change.
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
>
> "CML" <CML@discussions.microsoft.com> wrote in message
> news:93593703-E68D-48B8-AD54-E9F6F7201CF4@microsoft.com...
> > In Excel, I get an error message when trying to enter a negative dollar
> > amount. "You must enter a dollar amount in this cell." How do I enter a
> > negative amount without the error message and still have it add up
> correctly
> > at the ending column?
>

If he can *even get* to the validation window, that means the sheet isn't
protected.

Anyone who doesn't protect a sheet, even *without* a password, shouldn't be
creating any sort of restrictions that can so easily be breached as by
simply clicking on the toolbar.

If the OP finds and by-passes the validation,
IMHO - the sheet creator deserves what he gets !<vbg>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:OztKZ1JDFHA.3908@TK2MSFTNGP15.phx.gbl...
> >> which you can change.
>
> Or find out why it was there in the first place and if there was valid
> reason that negative values were prohibited :-)
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> --------------------------------------------------------------------------
--
> It's easier to beg forgiveness than ask permission :-)
> --------------------------------------------------------------------------
--
>
> "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
> news:OgmikvJDFHA.464@TK2MSFTNGP15.phx.gbl...
> > Select one of the cells with the error message, and then:
> > <Data> <Validation>,
> > And see if you get the validation window with a formula, which you can
> > change.
> > --
> > HTH,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
> -
> >
> > "CML" <CML@discussions.microsoft.com> wrote in message
> > news:93593703-E68D-48B8-AD54-E9F6F7201CF4@microsoft.com...
> > > In Excel, I get an error message when trying to enter a negative
dollar
> > > amount. "You must enter a dollar amount in this cell." How do I enter
a
> > > negative amount without the error message and still have it add up
> > correctly
> > > at the ending column?
> >
>
>

You got a mean streak in you!!! <vbg>

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:uoPee9JDFHA.2232@TK2MSFTNGP14.phx.gbl...
> If he can *even get* to the validation window, that means the sheet isn't
> protected.
>
> Anyone who doesn't protect a sheet, even *without* a password, shouldn't
be
> creating any sort of restrictions that can so easily be breached as by
> simply clicking on the toolbar.
>
> If the OP finds and by-passes the validation,
> IMHO - the sheet creator deserves what he gets !<vbg>
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
>
> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> news:OztKZ1JDFHA.3908@TK2MSFTNGP15.phx.gbl...
> > >> which you can change.
> >
> > Or find out why it was there in the first place and if there was valid
> > reason that negative values were prohibited :-)
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
>
> --------------------------------------------------------------------------
> --
> > It's easier to beg forgiveness than ask permission :-)
>
> --------------------------------------------------------------------------
> --
> >
> > "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
> > news:OgmikvJDFHA.464@TK2MSFTNGP15.phx.gbl...
> > > Select one of the cells with the error message, and then:
> > > <Data> <Validation>,
> > > And see if you get the validation window with a formula, which you can
> > > change.
> > > --
> > > HTH,
> > >
> > > RD
> > >
> >
>
> --------------------------------------------------------------------------
> > -
> > > Please keep all correspondence within the NewsGroup, so all may
benefit
> !
> >
>
> --------------------------------------------------------------------------
> > -
> > >
> > > "CML" <CML@discussions.microsoft.com> wrote in message
> > > news:93593703-E68D-48B8-AD54-E9F6F7201CF4@microsoft.com...
> > > > In Excel, I get an error message when trying to enter a negative
> dollar
> > > > amount. "You must enter a dollar amount in this cell." How do I
enter
> a
> > > > negative amount without the error message and still have it add up
> > > correctly
> > > > at the ending column?
> > >
> >
> >
>

I'm really lovable.
Ask my ex, she'll tell you.<g>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:%23oxorAKDFHA.3416@TK2MSFTNGP09.phx.gbl...
> You got a mean streak in you!!! <vbg>
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> --------------------------------------------------------------------------
--
> It's easier to beg forgiveness than ask permission :-)
> --------------------------------------------------------------------------
--
>
> "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
> news:uoPee9JDFHA.2232@TK2MSFTNGP14.phx.gbl...
> > If he can *even get* to the validation window, that means the sheet
isn't
> > protected.
> >
> > Anyone who doesn't protect a sheet, even *without* a password, shouldn't
> be
> > creating any sort of restrictions that can so easily be breached as by
> > simply clicking on the toolbar.
> >
> > If the OP finds and by-passes the validation,
> > IMHO - the sheet creator deserves what he gets !<vbg>
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
> -
> >
> > "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> > news:OztKZ1JDFHA.3908@TK2MSFTNGP15.phx.gbl...
> > > >> which you can change.
> > >
> > > Or find out why it was there in the first place and if there was valid
> > > reason that negative values were prohibited :-)
> > >
> > > --
> > > Regards
> > > Ken....................... Microsoft MVP - Excel
> > > Sys Spec - Win XP Pro / XL 97/00/02/03
> > >
> >
>
> --------------------------------------------------------------------------
> > --
> > > It's easier to beg forgiveness than ask permission
:-)
> >
>
> --------------------------------------------------------------------------
> > --
> > >
> > > "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
> > > news:OgmikvJDFHA.464@TK2MSFTNGP15.phx.gbl...
> > > > Select one of the cells with the error message, and then:
> > > > <Data> <Validation>,
> > > > And see if you get the validation window with a formula, which you
can
> > > > change.
> > > > --
> > > > HTH,
> > > >
> > > > RD
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > -
> > > > Please keep all correspondence within the NewsGroup, so all may
> benefit
> > !
> > >
> >
>
> --------------------------------------------------------------------------
> > > -
> > > >
> > > > "CML" <CML@discussions.microsoft.com> wrote in message
> > > > news:93593703-E68D-48B8-AD54-E9F6F7201CF4@microsoft.com...
> > > > > In Excel, I get an error message when trying to enter a negative
> > dollar
> > > > > amount. "You must enter a dollar amount in this cell." How do I
> enter
> > a
> > > > > negative amount without the error message and still have it add up
> > > > correctly
> > > > > at the ending column?
> > > >
> > >
> > >
> >
>
>

LOL :-)