| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format numbers to thousands
Hi
I would like to be able to format a large number like 125000 to 125. For instance 125000 + 125000 = 250000 would be shown as 125 + 125 = 250. :-) Klaus |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format numbers to thousands
Use a custom format of #,##0,
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "James7100" wrote in message ... Hi I would like to be able to format a large number like 125000 to 125. For instance 125000 + 125000 = 250000 would be shown as 125 + 125 = 250. :-) Klaus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
| Mail Merge - format of numbers | Excel Discussion (Misc queries) | |||
Linear Mode
