//some 3rd party need geo

Ledger to Excel anomaly

  Craig.m 20:07 10 Nov 03
Locked

When moving figures from Ledger (accounting software) to Excel, the numbers in ledger that are negative move over to Excel with the sign on the right (-1234 - reads into Excel as 1234-). I would appreciate it if anyone could let me know how I could use one of the Excel functions to read a number and also pick out if it has a negative on the wrong side then copy the value correcting the number to an Excel negative it is does have this misplaced dash or just the same value if it was a positive number.

I have looked and can find nothing that seems to do this conversion.

Craig

  VoG II 20:17 10 Nov 03

To convert a number in cell B2

=IF(ISNUMBER(B2),B2,VALUE(RIGHT(B2,1)&LEFT(B2,FIND("-",B2)-1)))

  Craig.m 20:22 10 Nov 03

Thanks VoG, I am not too bad with Excel at a normal level but that little bit is beyond me.

That aside, it works just as I want it to, thanks very much. Another satisfied customer :-)

Craig

This thread is now locked and can not be replied to.

What is Google Allo? What is Google Duo? Google Allo UK release date rumours and features: Google…

1995-2015: How technology has changed the world in 20 years

These clever designs help visualise a complex intelligence tool

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…