| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change 7 to 7000 (like in thousands)
HI, To change the format of 7 to 7000. I go to FormatCustom Number and I
enter .000 If I enter ,000 it goes like decimals. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change 7 to 7000 (like in thousands)
To change 7 into 7000, but only in format:
Format Cells... Number Custom General"000" -- Gary''s Student - gsnu200750 "Joe" wrote: HI, To change the format of 7 to 7000. I go to FormatCustom Number and I enter .000 If I enter ,000 it goes like decimals. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the character separating thousands or decimals on. | Excel Discussion (Misc queries) | |||
| I need to change the path of the linked files - thousands of them. | Excel Discussion (Misc queries) | |||
| Correct way to =IF(B6<7000,B6*0.45)=IF(B6<97000,B6*0.5) ...etc | Excel Discussion (Misc queries) | |||
| How do I change thousands to intergers on my spreadsheet? | Excel Discussion (Misc queries) | |||
| Rounding to thousands | Excel Discussion (Misc queries) | |||
Linear Mode
