Hi,
This is actually for my ebay spreadsheet, what i'm trying to do is ad in advertised shipping cost, but some times I do free shipping so I would like to enter a 0 into the cell and have the expression "FREE" replace the 0 but still have the zero numerical value.
Last edited by Rooster35236; 11-21-2010 at 10:46 AM.
Pretty sure can't do this, a cell can only have one value.
You could put in the adjacent (B2) cell, if it helps
=IF(A2=0,"FREE","")
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
You could format the cell as, for example, General;-General;"FREE"
Entia non sunt multiplicanda sine necessitate
Thanks guys,
You see i'm trying to get everything to fit on an 8 1/2 x 11 print out and I dont have any more room for another column. And that General;-General;"FREE" didn't work either, it throws off the next column to #VALUE
Didn't work in what fashion?
If you enter 0 in a cell formatted in that fashion, the cell displays FREE; is there something else it's supposed to do?
I wanted it to display FREE but still keep the zero numerical value
It does ... formatting just changes how numbers are displayed, it NEVER changes the underlying value.
Not sure if formatting number with "Free" is going to work as when there is in fact a number other than zero it will include free??
I think it may be better to change the cell that references it to assume zero if "Free" is in cell.
One lives and learns. I tried a few variations, but not this one
shgs' solution
Format Cells..... > Custom
Does the job
Please Login or Register to view this content.
Nice one shg, how does it work?
[EDIT]
Found this link that seems to explain it well, thanks for the nudge in the ribs shg
http://www.ozgrid.com/Excel/CustomFormats.htm
Last edited by Marcol; 11-20-2010 at 11:05 PM.
It just displays 0 as the text FREE; nothing exotic, Marcol.
OK, Awesome! it works, Shg was totally correct. I'm just an idiot I was trying to input General;-General;"FREE" into the formula bar, not format cells.....custom. Thanks it works great!
Last edited by Rooster35236; 11-21-2010 at 10:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks