Custom number format "m"

  • Thread starter Thread starter Paul B
  • Start date Start date
P

Paul B

I'm trying to define a custom number format "#,##0.0 cfm" but for some
reason I am not able to put the letter "m" in the definition for my format.
The "cfm" stands for cubic feet per minute. Anyone have any suggestions on
how to get around this? It seems strange that I am able to define "#,##0.0
ft^3" but not cfm. Why would Excel (I'm using Excel 2000 9.0.4402 SR-1) not
allow the use of the letter "m"?!?

Is there anyway to accomplish what I am trying to do?

Thanks,
Paul B
 
Paul,

#,##0.0 "cfm" seems to work.

Regards,

Jim Cone
San Francisco, CA
*****************
 
Hi Paul,
By trial and error I found I could use: #,##0.0 "cfm"
that is, with the text in quotes which do not show in the cell.
Very odd! I could use cff but not abc without quotes.
Bernard
 
One more way:

#,##0.0 cf\m

the \ tells excel that you really want the m--you're not using a code for minute
(like in hh:mm:ss)
 
Thank you all for your help. It's interesting that I put the "m" in quotes
to specify it to the people in this newsgroup, but never thought to do it in
Excel to specify it to the program.

Another new lesson learned
Thanks,
Paul B
 
Back
Top