Formatting a cell for numbers, with text

[hornetster]

Want to have a column that is formatted eg 1,000km (one thousand kilometres), so that I just enter “1000”, and the cell converts it to 1,000km, and the column can be numerically manipulated.

How do I format this?

(and just as another query, what has happened to this forum, I couldn’t even figure out where to go and ask the question in a relevant space…???)

Thanks.

[robleyd]

@hornetster

what has happened to this forum

You may wish to read This is the guide - How to use the Ask site?

[keme1]

@hornetster

I just enter “1000”, and the cell converts it to 1,000km

Basically

• Select menu item Format - Cell
• Select tab Numbers in the format dialog
• In the Format code field, enter the appropriate code for your desired output.
  • If you want an entered zero to show as 0 km: #,##0" km"
  • If you want zero km to display as just km: #,###" km"
  • If you want zero km to display as a blank cell, you need to specify separate format specifiers for positive, negative and zero values: #,##0" km";-#,##0" km";""
• Make sure the language field (top right in the dialog) holds a locale which uses comma for thousands separator.

Ideally
Same as above, but do it in a (new?) cell style. Apply that style to the cells which needs the formatting.

@hornetster

what has happened to this forum

It changed platform, from a forum site structured hierarchically to a Q&A site structured by tags/filters.

The authoritative information sources are of course the ones linked in the responses from @robleyd.

[robleyd]

Perhaps this will help:

User-Defined Number Formats