Return to index: [Subject] [Thread] [Date] [Author]

excel custom formats

[Subject Prev][Subject Next][Thread Prev][Thread Next]
i know how to make cells display text next to the number value of the cell.
what i don't know is how to make the number's format work like the "general"
format.  

so if a user inputs
20
the cell displays 
20 psf

and if a user inputs 
20.65
the same cell displays
20.65 psf

can this even be done?

tia
da


* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org