Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I know that LibreOffice allows you to define custom number formats. I have a spreadsheet that displays some smallish percentages (all are less than 1%). I would like to use permille instead.

Percentages less than one percent cause confusion with people looking at the spreadsheet as percentages are often interchanged with decimals 0.34 -> 34%. I've often seen spreadsheets where .34% was written and people have assumed this meant 34%, also I've seen cases where the author meant 34% but the value in the cell was .0034

I looked at the Format code for percent to see if there was any special trick I could use, since for a percentage the decimal point is moved 0.5 -> 50%, which is different from changing the thousand separator or the number of decimal places.

The "Format code" for percent looks like this: 0.00%

It looks like the % symbol has a special interpretation and I can't just tell the format to multiply by 1000 and append the permille symbol as a work-around I am using

=ROUND({originalCell}*1000,2)&"‰"

but this changes the value and makes the cell mixed number/text. Is there any way I can create a custom format for this?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.