Excel Formating - Millions

J

jtidyman

Is it possible to format cells in excel so that the value of 1000000
would be come 1m? I know this is possible with thousands using k, is
something similar available for millions?
 
N

Norman Harker

Hi jtidyman!

Try custom format:

#,###,,"m"


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top