Copy and paste

[kobus_Jhg]

@Patch

When you have a number in the cell, the number formats will work

When you sum over only numbers the sum formula will work

@Patch @eko @p4unger @mick This is interesting.
I did a different calculation to test

This still give values although as far as my knowledge I have selected all cells and coverted it to numbers.

[Patch]

What version of Manager are you using?

Lubos optimised copy to clipboard for data import over formatting relatively recently

@kobus_Jhg

although as far as my knowledge I have selected all cells and coverted it to numbers

Do number formats work? They do not appear to have indicating you have text not numbers

[VACUUMDOG]

Straight out ‘copy to clipboard’ and paste into excel. Cells not reformatted from general.

All works as expected. Excel 2016, manager 21.5.35. even if there is text in one of the cells. (there is text in cell C:11 not shown in screen shot)

[kobus_Jhg]

@Patch

What version of Manager are you using?

@Patch Version 21.4.27

[kobus_Jhg]

@VACUUMDOG

All works as expected. Excel 2016, manager 21.5.35. even if there is text in one of the cells. (there is text in cell C:11 not shown in screen shot)

@Patch @eko @VACUUMDOG Looks like I do not have the latest version. Maybe that could be the problem. Is there a upgrade option or should I re-download Manager again. If I do? what happens with my current data?
@lubos I am just asking. Should manager not update automatically when there is a new version?

[VACUUMDOG]

First of all DO A BACKUP
Download the latest version from manager.io
Install…
Everything should still be there.

[kobus_Jhg]

@VACUUMDOG @Patch @eko Maybe this could solve the problem. I will update and try again.

[kobus_Jhg]

@kobus_Jhg

Maybe this could solve the problem. I will update and try again.

@VACUUMDOG @Patch @eko Nope I upgraded to the new version. No Change.

[lubos]

@kobus_Jhg Is it just negative numbers which are causing issue in Excel? How about your sales figure which is positive number?

[kobus_Jhg]

@lubos

Is it just negative numbers which are causing issue in Excel? How about your sales figure which is positive number?

@lubos @Patch @VACUUMDOG @eko Positive numbers are a problem as well. I did upgrade to the latest version of Manager. If it will help, I have Excel version 2010.

[eko]

@kobus_Jhg

I have Excel version 2010.

That is 11 years old. Try Libre Office (is open source). If it works then time to update your Excel.

[kobus_Jhg]

@eko

That is 11 years old. Try Libre Office (is open source). If it works then time to update your Excel.

@eko It does not download. Maybe there is an error with the link.

[Patch]

Did you go here https://www.libreoffice.org/
Btw Microsoft office 2007 works OK for me

[kobus_Jhg]

@Patch

Did you go here https://www.libreoffice.org/

@Patch Yes I did

[Joe91]

What Operating system are you using?

[VACUUMDOG]

What does the exclamation mark symbol reveal?

[kobus_Jhg]

@Joe91

What Operating system are you using?

@Joe91 Windows 10 Enterprise LTSC 2019

[AJD]

Put this formula in the next column

Then copy it down like this

Then see if formulas work summing this new column

If it still does not work post a screen shot with “show formulas” selected.

[Patch]

Or change the number format
or paste the formula (with the cell reference adjusted as appropriate)
= value(B7)
then sum that column

[kobus_Jhg]

@AJD @Patch @eko @VACUUMDOG @Joe91 @lubos I have done the following: -

If one looks at these 2 columns, the 1st column Is as copied and pasted from Manager re-formatted as the number format. In the 2nd column I have retyped the 2 amounts (-833.33 and -434.78) These 2 numbers is the real number format, because it is aligned on the Right of the cell and it adds up. This means all numbers copied from Manager will still have to be re-typed in order to do calculations.
Looks like the “copy to clipboard” and “paste” to excel does not work.