eturn data value and manually key in measured units in the same cell

[PracticingEngineer]

How can I return a data value and manually key in the measured units in the same cell?

Thanks,

 

[mgp]

You can't

Assuming what you're trying to do is to use a calculated value for another calculation and then update the (second) calculation with the measured value, then the cell must include a formula to get the first value and you will erase that by typing the measured value.

What you need to do is to store the calculated value in another cell. You can then:

1. Manually copy the value of the calculated cell across to the other cell.

2. Make a macro with a button to do the same thing

3. Make a third cell select which value to use and use the third cell for the onwards calculation, e.g. if

Cell A1 contains the calculated value
Cell A2 contains the measured value
Cell A3 contains =IF(ISBLANK(A2);A1;A2)

Use The value of cell A3 for the onwards calculation.
If Cell A2 is empty, (no measured value) then the calculated value is used, if A2 is not empty then the measured value is used.

Hope this helps
Regards
Mogens

 

[TomSD]

mgp is right but you can make a custom format that includes your units as text with the number; e.g.
- select cell
- click on Format, then Cells
"Format Cells" dialogue/palette comes up
- select "Number" tab
Intially cells are usually "General" format
- choose desireable format, e.g. "Number"
Choose number of digits to display, whatever
- now choose "Custom" (should be at bottom of list)
A format input box (under "Type:&quot comes up,
a separate list box below.
Your number format is shown in the input box
- Type your units as text in quotation marks,
after the number format, in the input box,
including a space after the number format, if desired,
or after the initial quote,
e.g. 0.00 "amp"
- The newly created format is added to the list box,
is automatically applied to the existing cell
when you click OK,
and can be chosen for other cells using Format - Cells.

The number in the formatted cell is used for onward calculations in other cells, the text isn't involved.