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