Scaling numbers for display

H

Hershmab

A set of decimal values represents (say) lengths in metres. How can they be
formatted so that each individual value is displayed as millimetres,
centimetres, metres, ... etc. according to its magnitude? Can this be done
using formatting alone, or only with a formula?

Can the same thing be done for (say) Imperial/US lengths in inches, feet,
yards etc.?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set uniform scaling for same type of Pivot charts with varying dat 1
Row of numbers adding incorrectly. 4
Adding an alpha prefix to page numbers 3
VBA required to total numbers to match closest to target (complex one...) 14
Web Query Formatting not ready for Production 0
Formatting text as numbers 4
Formatting numerals and text numbers between Arabic and Hindi (indic) languages 6
Linked Charts Lose Formatting 1

Top