Number Format

D

Damien

Is it possible to have a number format for thousands of
pounds?

eg format
'10,000' as '10K'
'100,000' as '100K'
etc

I know this could be done with a formula, but am wondering
if it can be done with a custom number format.

Thanks


Damien
 

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

number formats for y-axis 1
convert number to % using only custom number format challenge 7
Format cell to always begin with an "X" 2
excel trendline label error 2
How do I make a graph with 2 "Y-Axes" at different scale? 2
Number format 1
Custom Number Format for text 8
custom format 1

Top