Return to index: [Subject] [Thread] [Date] [Author]
RE: excel custom formats
[Subject Prev][Subject Next][Thread Prev][Thread Next]- To: "'seaint(--nospam--at)seaint.org'" <seaint(--nospam--at)seaint.org>
- Subject: RE: excel custom formats
- From: "Jones, Mark A" <Mark.A.Jones(--nospam--at)jacobs.com>
- Date: Wed, 15 Aug 2001 09:43:37 -0700
David,
Click on the cell
go to Format|Cell (or right
click and select format).
Select the Number tab.
in the "Type" box put
"#.?? psf".
#'s are required digits and ?'s are optional digits. So
in this case if you entered 20 it would appear as 20 psf and 20.65 would appear
as 20.65 psf.
Also see the Excel Help item "Create a custom
number format". The following is an excerpt from "About number format
codes for decimal places, spaces, colors, and conditions":
Decimal points
and significant digits To format fractions or numbers with decimal
points, include the following digit placeholders in a section. If a number has
more digits to the right of the decimal point than there are placeholders in the
format, the number rounds to as many decimal places as there are placeholders.
If there are more digits to the left of the decimal point than there are
placeholders, the extra digits are displayed. If the format contains only number
signs (#) to the left of the decimal point, numbers less than 1 begin with a
decimal point.
# displays only significant digits and does not display
insignificant zeros.
0 (zero) displays insignificant zeros if a
number has fewer digits than there are zeros in the format.
? adds
spaces for insignificant zeros on either side of the decimal point so that
decimal points align when formatted with a fixed-width font, such as Courier
New. You can also use ? for fractions that have varying numbers of
digits.
To
display Use
this code
1234.59 as
1234.6 ####.#
8.9
as
8.900 #.000
.631
as
0.6 0.#
12
as 12.0 and 1234.568 as
1234.57 #.0#
44.398,
102.65, and 2.8 with aligned decimals
???.???
HTH,
Mark Jones
Jacobs Engineering
NOTICE - This communication may contain confidential and privileged information that is for the sole use of the intended recipient. Any viewing, copying or distribution of, or reliance on this message by unintended recipients is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer.
==============================================================================
- Prev by Subject: Re: excel custom formats
- Next by Subject: RE: excel custom formats
- Previous by thread: RE: excel custom formats
- Next by thread: RE: excel custom formats
- About this archive
- Messages sorted by: [Subject][Thread][Author][Date]