| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Data
I am extrcting data via DDE from excel to another program
Is there a way to keep the formating og the number when the data is extracted example: cell formula=J28/I2 Displayed=23 What is extracted = 0.232786543998 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Data
change the formula to round(J28/I28,2) so that the value extracted will
be 0.23 Theo Fanelli wrote: I am extrcting data via DDE from excel to another program. Is there a way to keep the formating og the number when the data is extracted? example: cell formula=J28/I28 Displayed=23% What is extracted = 0.2327865439983 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Data
You can do =round(J28/I28,2)*100&"%"
Theo Fanelli wrote: Thank you for your reply. What I would like to extract is 23% is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
| converting numerical data in one cell to word data in another cell | Excel Worksheet Functions | |||
| how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
| moving data to a cell, not pulling data to the cell | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
Linear Mode
