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

Re: excel custom formats

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Hi David.

I think it is such a piece of cake , you can follow as the below sequences
in Excel menu:
- Format -> Cell ( or press : Ctrl + 1)
- In " Number " Tab -> Choosing "Custom" Category:
- In type box , fill in :     #,##0.00 "psf"
if you want 2 decimal places plus sufix "psf" or whatever
Hope this helps
Strurocky

----- Original Message -----
From: David Adie <dadie(--nospam--at)bjginc.com>
To: <seaint(--nospam--at)seaint.org>
Sent: August 15, 2001 10:19 PM
Subject: excel custom formats


> 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


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