Back to Blog
Diet formula decipher text7/6/2023 ![]() If I get by without needing the extra columns (like colC and colD above),then that would be great, but I need to have the negative values appear as say X-3.452 and Y-1.500 instead of having the negative sign go before the X and Y letters. I ended up copying the values in colA and colB to create colC and colD, and then for colD set it to =”Y”&A1 or =CONCATENATE(“Y”,I3), and that fixes the issue so the – sign will be after the Y (which is what I want), but it just lists the number to two digits (drops off the zeroes) instead of the three digits that I’d like. 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.
0 Comments
Read More
Leave a Reply. |