when using the copy to clipboard, the positive numbers get formatted as number in excel but the negative ones get formatted as general and cant be changed.This is creating problems as the amount columns are not equal. Please solve the issue Thanks

Can you give an example with screenshots? I am not facing an issue, both Excel and Libre Office show the positive and negative numbers in a standard way.

[image] rajansharma9208: and cant be changed Can’t be changed where? In your spreadsheet? That sounds like a spreadsheet problem, not anything to do with Manager. Most spreadsheet applications have many options for formatting, pasting, etc. Remember that Manager outputs in CSV format, not Exc…

Yes, in the spreadsheet.The formatting always gets jumbled. [image] I have shared a screenshot. Here you can see the positive and negative data. The issue is that the negative ones get formatted as general every time and cant be changed to numbers

Please explain where this data came from, i.e. where you clicked the copy to clipboard and pasted data into a spreadsheet from. Also which spreadsheet application do you use?

The answer to your problem is probably in this very long thread. [image] Copy and paste How do I copy and paste from the package on excel so that I can use a formula. I can copy and paste to excel but the amounts have to be retyped out so that I can use formulas. How do…

In addition to @AJD the solution is in post 45 at Copy and paste - #45 by AJD

I copied it from bottom right corner of the ledger in manager.io ,think thats the only way to copy. I pasted the data to MS-Excel

From which ledger account ? (Note Manager does not use the term ledger).

[image] rajansharma9208: I pasted the data to MS-Excel And did you use a blank, new, worksheet?

[image] rajansharma9208: The issue is that the negative ones get formatted as general every time and cant be changed to numbers As I already aksed, cannot be changed where? How? Are you saying you cannot change the format of a cell in your spreadsheet? That’s a spreadsheet issue, not a Manage…

Issue with copy to clipboard

eko January 6, 2023, 8:54am 15

The solution was given in earlier post by Issue with copy to clipboard - #6 by AJD Just try the solution in post 45 at Copy and paste - #45 by AJD

Topic		Replies	Views
Improve copied report formats ideas	16	474	April 15, 2026
Numeric Figures are not Recognised	15	640	September 22, 2021
Negative numbers appear as text when converted from tsv to excel	11	1209	September 9, 2015
Copy and paste	84	1540	May 30, 2021
Data is neither text nor number	23	830	September 4, 2021

Issue with copy to clipboard

Related topics