paxagile.blogg.se

How to merge 2 cells in excel and keep the data
How to merge 2 cells in excel and keep the data




how to merge 2 cells in excel and keep the data

The issue is, that I need to have the negative value appear as Y-1.500 instead of -Y1.500. If I select cell A1 and choose Format Cell/Number/Custom and use “X”0.000 and then “Y”0.000 for cell B1, then they will appear as X3.150 and -Y1.500. I want to add an X in front of the column A values and a Y to the column B values as I want to then copy and paste the values into another file (writing simple G code for a CNC mill). Hello!! I’m working on a file where I will have positive and negative numbers in columns A and B like is shown below, with those columns being calculated from various cells.






How to merge 2 cells in excel and keep the data