How to append text to calculated values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

blah - 15 Sep 2005 20:16 GMT

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?

Reply to this Message

KL - 15 Sep 2005 20:23 GMT

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

>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?

Reply to this Message

Roger Govier - 16 Sep 2005 00:13 GMT

Hi

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

Regards

Roger Govier

> 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?

Reply to this Message