Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Number Formats
I'm working with someone else's worksheet where they've formatted a cell's
number value as "custom" and it's this: "B/." with the end resuls showing as: B/. 3,850 This was the total sum of 4 other cells. What is the "B/." format--what does it mean??? |
#2
|
|||
|
|||
It inserts literal text into the format -- whatever is enclosed in the quote
marks. In this case, that's 3 characters, B/. But I expect the actual format string is something like "B/."#,##0 With "B/." only, you would not see the 3,850, just B/. On Sat, 24 Sep 2005 11:52:02 -0700, "Dan Swartz" <Dan wrote: I'm working with someone else's worksheet where they've formatted a cell's number value as "custom" and it's this: "B/." with the end resuls showing as: B/. 3,850 This was the total sum of 4 other cells. What is the "B/." format--what does it mean??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox Number Formats | Excel Worksheet Functions | |||
Phone Number Formats | Excel Discussion (Misc queries) | |||
Format Cell (Number Custom) | Excel Discussion (Misc queries) | |||
number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |