@PeterJones said in Format different in regular notepad after installin notepad++ HELP!:
ttings in such a way that the source name is copying. I cannot explore different Excel settings for you, but can confirm that with the way mine is set up, copying from one workbook to another doesn’t make it link the data: the formula stays local to the workbook.
These are Excel problems, not something specific to Notepad++, so from here on out, you should probably move to an Excel forum. You should probably ask one or two questions – which are separate ideas, though the second isn’t as important now that you know that Excel should be able to handle the copy/paste with formulas correctly.
The first question would be worded something like “when I copy formulas from one workbook to another, for me it inserts the source workbook name into the destination formula, so it creates a link between the workbooks, but I am wanting to copy the formulas to the new workbook so that the formulas are relative to the new workbook. (And when I asked a similar question in a wrong forum, I was told that in circumstances of someone over there, Excel didn’t make the formulas a link, and did what I expected. Could you help me figure out how to make the pasted formulas reference the cells in the new workbook, rather than be formulas with links to the old workbook for the data?” You could include screenshots similar to above, but showing how the formulas don’t work right.
If you really needed to know why the thru-text-editor didn’t work, you could also ask, “Second, why when I Formulas > Show Formulas, and copy/paste the formulas into a text editor like notepad.exe or Notepad++, and then copy/paste from the text editor into a new Excel workbook, why does a multi-line formula first get interpreted as text, until I F2-edit then hit enter, when Excel properly treats it as a formula again?”
But again, this is all stuff for the Excel forum of your choice.
I completly understand not going far into excel, this is a notepad++ forum after all. thanks for thaking the time to look into this! I will look further in the excel forums. ill be back if anything points back to N++ but youre probably right and its to do with excel. Thansk again Peter!