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??? |
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??? |
All times are GMT +1. The time now is 09:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com