number format

A

A

Hi
Is there any way to format a number to 1 decimal place which includes the
currency symbol at the start and text at the end eg m (for millions).

eg £24.5m

I want to change the format so that I can still add a list of numbers

Regards
Adrian
 
D

Don

How about formatting fractions. 5/32 is displayed as 11810 when you format to
fractions containing two digits eg 25/32
 
D

Don

Forgot to request notification of a reply to my question of why formatting
fractions in excel 2007 such as "5/32" results in 11810.
 
D

David Biddulph

Excel dates count from 1 Jan 1900. 11810, if formatted as a date, is 1 May
1932. Excel has interpreted 5/32 as May 1932.
 

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

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Mail Merge - displaying a conditional number of decimals 5
Finding the proper style field and the numbered paragraph value within the style 0
How to change font & size of (all) citation numbers? 7
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2
Page numbering with Merged Document and IF statements 1
Stop XL from changing format? 1

Top