Rupees with Paise
From Bill Manville via Niek Otten via Dave Peterson: [>9999999]"Rs."##\,##\,##\,##0.00;[>99999]"Rs."##\,##\,##0.00;"Rs."##,##000
Rupees without Paise
[>9999999]"Rs."##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs."##,##0
Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]"##\,##\,##0.00;"##,##0.00 |
Rounding to thousands
How do I round 123,456,789 to the nearest millions or thousands without
using a formula?
From Bob Phillips
[>999999]#,##0,\M;[>999]#,##0,\T;#,##0
|
Squared
Q: How do I type a little 2 next to the number in order to show it is a
squared number?
From Ron Rosenfeld <ronrosenfeld@nospam.org>
microsoft.public.excel.misc 24-June-2005
A: If you want the value to be treated as a number, so as to do
calculations on it, then you need a custom format:
Format/Cells/Number/Custom Type: 0.0<alt-0178>
<alt-0178> means hold down the <alt> key while you type 0178 on the
numeric keypad. This will not work if you use the number keys above the
regular keyboard.
You may replace the 0.0 by whatever number format you want. |
