Hi, looking for way to omit characters (numbers) in custom format where
examples might be: 1.5M 1.5B and/or 1.51BM 1.51B thanks.
to allow something like?: (not sure what correct version should be)
#,##0? (quot;?quot; for any alpha-character)
0?
#?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...lic.excel.misc
- Oct 22 Sun 2006 20:09
MS suggestion, disregard: Custom Format Text
close
全站熱搜
留言列表
發表留言