Hi
I hope somebody can help me. i have cell (B1) that has a number in it. I have this cell formatted to a number with 2 decimal places (5.00). In another cell I
want to put text that includes the value of cell B1. Cell formatting is set to general. So I am putting in the cell ="G90G0X"&B1 . This comes out as G90G0X5 without the decimal place. This is code for a CNC machine where thw X5 tell the machine a position to go to but the machine will read X5 as X.005 where no decimal is present. So in short I need the decimal. Cell B1 is a calculation, so this could be a number with decimal places or a whole number. Is there anyway to make a decimal appear in the answer.
Thanks
Bookmarks