How to append text to calculated values

B

blah

I have a cell that calculates power in Watts. I'd like to append a W in the
same cell, anyone know how to do this?
 
K

KL

Hi,

If you want your value to remain numeric then just Format>Cell, tab: Number,
category: Custom, type: [General "W"] or [0.0 "W"], etc. (all without
brakets)

If you want a text string then change your formula as follows
=YourFormula&" W"

Regards,
KL
 
R

Roger Govier

Hi

Format>Cells>Number>Custom and enter in the pane 0 "W"


Regards

Roger Govier
 
Top