| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula which could change -£1.50 to £1.50 in Excel?
It's a pain,but my accounting software reports my cheque values as minus.
To be useful in the spreadsheet they should be positive numbers, - but there are hundreds! could you please help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a formula which could change -£1.50 to £1.50 in Excel?
I answered a very similar enquiry just a few days ago - you can see it
he http://groups.google.com/group/micro...044c69c131a456 Hope this helps. Pete On Jan 22, 9:30*am, MichaelOfficer wrote: It's a pain,but my accounting software reports my cheque values as minus. To be useful in the spreadsheet they should be positive numbers, - but there are hundreds! could you please help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a formula which could change -£1.50 to £1.50 in Excel?
On Jan 22, 4:30*am, MichaelOfficer
wrote: It's a pain,but my accounting software reports my cheque values as minus. To be useful in the spreadsheet they should be positive numbers, - but there are hundreds! could you please help me? Assuming your value is in A1 : =ABS(A1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does Excel change a date into a formula? | Excel Discussion (Misc queries) | |||
| Formula in excel to change - to + | Excel Discussion (Misc queries) | |||
| Why Excel does automatically change the formula? | Excel Worksheet Functions | |||
| Change height of the Formula Bar in Excel? | Excel Discussion (Misc queries) | |||
| Excel formula to change a value every 2 weeks | Excel Discussion (Misc queries) | |||
Linear Mode
