LinkBack URL
About LinkBacks
When a user enters an amount in a cell, in £'s, i need it to show a negative amount. So if they enter £100 I want excel to regard it as -£100.
Is this possible.
Many thanks
David
When a user enters an amount in a cell, in £'s, i need it to show a negative amount. So if they enter £100 I want excel to regard it as -£100.
Is this possible.
Many thanks
David
Last edited by EXCELNEWCOMER; 01-19-2010 at 04:57 PM.
hi david,
you may try this
1. right click on the cell
2. select format cell
3. select "number" tab
4. select custom
5. copy and paste this: -$#,##0.00;[Red]$#,##0.00
pls note this doesn't change the value to a negative. this only formats the value.
hope this is what you are looking for!
is there away of making it negative ?
Last edited by teylyn; 01-19-2010 at 04:46 PM. Reason: deleted spurious quote
Excelnewcomer, please don't quote whole posts.
would it not be possible to enter a negative number in the first place if you want it to be a negative number?
You could use one cell for data entry, and then another cell for converting the value to a negative number, like
=if(A1<0,A1,-A1)
Ok I will think on it. It's just relying on the person entering the data to make it negative I wanted a full proof way.
Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks