Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format: Convert No. to thousands
Any idea, how to convert an entry of 2,153 be displayed/converted to
2,153,000, i.e. zeros' format? -- Thanx in advance, Best Regards, Faraz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format: Convert No. to thousands
OR if you are looking at converting while you enter the numbers then..
ToolsOptionsEditcheck 'Fixed decimal' and adjust 'Places' to minus 3 (-3) Now try entering 1253... -- Jacob "Faraz A. Qureshi" wrote: Any idea, how to convert an entry of 2,153 be displayed/converted to 2,153,000, i.e. zeros' format? -- Thanx in advance, Best Regards, Faraz |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format: Convert No. to thousands
Jacob u r the best buddy!
-- Thanx again, Best Regards, Faraz "Jacob Skaria" wrote: OR if you are looking at converting while you enter the numbers then.. ToolsOptionsEditcheck 'Fixed decimal' and adjust 'Places' to minus 3 (-3) Now try entering 1253... -- Jacob "Faraz A. Qureshi" wrote: Any idea, how to convert an entry of 2,153 be displayed/converted to 2,153,000, i.e. zeros' format? -- Thanx in advance, Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert list of different numbers to thousands | Excel Discussion (Misc queries) | |||
How do I format a number to cut off the thousands? | Excel Discussion (Misc queries) | |||
Convert Hundreds to Thousands | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Convert to # in Thousands | Excel Worksheet Functions |