Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Assuming the number in column B needs to be 2 decimal places...
A1 = 710 B1 = 23.20 Enter this formula in C1 and copy down as needed: =A1&TEXT(B1,",0.00") -- Biff Microsoft Excel MVP "Qaddoumi" wrote in message ... Dears, I am trying to do by formula the following but I failed: I have two columns, one has the distance and the other has the height level, and to draw it at the AutoCAD I need to put them in one column with comma in between like First column has the number: 710 Second column has the number: 23.20 I need to create new column to have: 710,23.20 Is it possible without typing it manually? Please help me, I really need it. |