optimising formats for minimum column widths

D

dido22

Hi,

This is a tricky question to explain.

I have a spreadsheet which has many columns of numbers in currency format. I
am trying to minimise the column widths so that I can see more of them
without having to scroll right / left.

If I have a number £2500.00, I can format it as £2.5K. If its value is
£2501.00, I can format it as £2501. If its value is £2501.36, I have
to format it as £2501.36.

I know how to format numbers & this is not a problem, but is there anyway of
automatically formatting a number to use the minimum column width?
..

With thanks

KK
 

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

Top