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

RE: excel custom formats

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Title: RE: excel custom formats

yes it can.

go to
cells (select number tab)
custom (category)
select the number format
in the "type" box place the desired text (psf in this case) and press OK.

it should work.

-----Original Message-----
From: David Adie [mailto:dadie(--nospam--at)]
Sent: Wednesday, August 15, 2001 10:20 AM
To: 'seaint(--nospam--at)'
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"

so if a user inputs
the cell displays
20 psf

and if a user inputs
the same cell displays
20.65 psf

can this even be done?


******* ***
*   Read list FAQ at:
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) or UnSubscribe, please go to:
*   Questions to seaint-ad(--nospam--at) 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: ********