Ask Your Question

how do you change from metric to imperial

asked 2020-01-16 14:22:51 +0100

Frustrated25 gravatar image

I want to change the formatting to imperial from metric. How do I do that?

edit retag flag offensive close merge delete


Please delete all duplicates of this question. Thanks in advance …

Opaque gravatar imageOpaque ( 2020-01-16 14:29:34 +0100 )edit

You need to be much more precise.

There are some related settings for the user interface. But. assuming you have set your interface and your locale to en(USA), these should be by default as you like them.

If the question is about numeric contents or results in spreadsheet cells you need to convert them explicitly. It is not a question of formatting.

Lupp gravatar imageLupp ( 2020-01-16 15:18:32 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-01-17 22:19:56 +0100

keme gravatar image

how do you change from metric to imperial?

You don't. It's the other way around. The use of imperial measures must be abandoned. Now!

On a more serious note:

how do you convert measures from metric to imperial?

That depends on the measure. You can multiply/divide a certain coefficient, or use the convert_add function.

I want to change the formatting ...

That makes sense.

There is no builtin formatting for all the subdividing units in imperial measures, so if you want e.g. to lay out a number of pounds in stone/lb/oz/pwt, you have to calculate the individual numbers yourself and put them together to a display value. Generally, you do this by taking the integer quotient and continue calculating on the remainder.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-16 14:22:51 +0100

Seen: 41 times

Last updated: Jan 17