ExcelBanter - Change 7 to 7000 (like in thousands)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Change 7 to 7000 (like in thousands) (https://www.excelbanter.com/excel-discussion-misc-queries/162741-change-7-7000-like-thousands.html)

Joe

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?

Gary''s Student

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?

All times are GMT +1. The time now is 05:11 AM.