Format numbers with suffixes

D

Dave Olson

Hi-

I am looking for a way to format data in Excel so that it
will have SI suffixes (micro: 'u', nano: 'n',
pico:'p'...etc). Is there a custom format that I can use
or another way anyone has tackled this? It really makes
data more readable.

Thanks,
Dave
 

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

ASK Field Formatting 1
Inconsistent formatting of section numbers 0
using a conditional suffix in text function format syntax=text(value,format_text) 1
Autonumber field in Excel that behaves the same as Access 0
Conditional Formatting from a group 6
Extract item numbers with suffix -09 and copy them below the actuallist 7
Is there a universal file savings format? 2
Mail Merge query 1

Top