PDA

View Full Version : Solved: Copying a cells "formating" into text



DanOfEarth
02-09-2009, 09:58 AM
I'm missing something REALLY basic here but I haven't had to deal with it before. Here's the three cells (ultimately will be columns)

A1
Allspice Ground BAG

B1
/$5.20lb (actual number is 5.2....custom cell formatting changes it to /$5.20lb)

C1 needs to read as text:
Allspice Ground Bag /$5.20lb

So far I've got

C1
=A1&" /$"&"B1&"lb"

This isn't working by not displaying my last zero. It's returning:
Allspice Ground BAG /$5.2lb

I need my zero.:bawl (/$5.20lb)

There's gotta be a basic worksheet function that either handles that or bypasses the whole formating business altogether.

nst1107
02-09-2009, 10:19 AM
Try this: =A1&" /"&TEXT(B1,"$0.00")&"lb"

DanOfEarth
02-09-2009, 10:41 AM
Well spank me and call me Sally! That worked. Thanks Nate.

I knew it had to be the Text function.:jawdown: But I did a search on it in HELP and it went nowhere.