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

Re: excel custom formats

[Subject Prev][Subject Next][Thread Prev][Thread Next]
--- David Adie <dadie(--nospam--at)bjginc.com> wrote:
> i know how to make cells display text next to the
> number value of the cell.

How do you do this?

Rajendran

> 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
> 
> 
> ******* ***
> *   Read list FAQ at:
> http://www.seaint.org/list_FAQ.asp
> * 
> *   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 
> ******** 


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

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