Re: - signs at back of number so won't add up, please help!


hi!

select the range of your data!
goto menu bar

Data > Text to Columns > Select Fixed width > Select General in Data
Format >>finish

you'll get the desired result!

-via135


Elkar Wrote:
Here's one possible solution.

Insert a new column and use the following formula:

=IF(RIGHT(A1,1)="-",VALUE("-"&SUBSTITUTE(A1,"-","")),A1)

This will move the - sign to the front of all values if they have it,
otherwise leave the value as is.

You can then perform your SUM on this new column, or "COPY" and "PASTE
SPECIAL - VALUES" over your original data. Then delete the new
column.

HTH,
Elkar

"Adam" wrote:



I copy data into excel from an accounts programme, but all the minus
signs
are at the back so Excel won't add these numbers up

i.e 4
3-

Th answer comes to 4 rather than one , what can I do about this?

Thanks for your help Adam

I know you guys/girls know an answer


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26725
View this thread: http://www.excelforum.com/showthread.php?threadid=515835

.

Relevant Pages

  • Re: zero values in bar chart
    ... If column or bar, what did you want - how do you want to plot ... If zero always means zero, then you should definitely trust your ... Create a second column data series, with the values of N or 0 as ... above, then format the series with the pale fill, or no fill. ...
    (microsoft.public.excel.charting)
  • Re: Bar Text Wont Display In Gantt Chart
    ... Would it not be simpler to use the precedence feature of the format bar ... critical bar styling to format the deadline style for critical tasks. ... not in the master file. ...
    (microsoft.public.project)
  • Re: Baby Sleep log
    ... Click the Format... ... headings as could be 'in crib' and 'in arms'. ... and 'in arms' just put a 1 in each appropriate cell. ... So what you see is a series of bar graphs. ...
    (microsoft.public.excel.charting)
  • Re: Date and Time in menu bar
    ... Click on the time in the menu bar. ... under the Format tab for say Medium, select all the formatting items, and then Edit->Copy. ... Still under the Format tab, Customise the Medium date format and paste the copied items where you want them to appear, and add some spacing if you wish. ... it's a bodge and there is I imagine the danger that the date may now appear twice where some software is using the time/date formats to display a time and date. ...
    (uk.comp.sys.mac)
  • Re: Error message from task bar in Gantt chart
    ... corruption in the problem subproject file. ... If I open the subproject outside of the master, ... In the Bar Format dialog ... using the Bar Shape tab to change only the Color, ...
    (microsoft.public.project)