Custom Number Formats

[Guest]

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

 

[Myrna Larson]

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