Thread: Rounding
View Single Post
  #1   Report Post  
PricklyFlower
 
Posts: n/a
Default Rounding

Hi there, can anyone help me?

If I've got a figure in a spreadsheet, say £5,678,123 and I want this figure
to be shown as £5.68 (as in £5.68 million), is there an easy way of entering
a formula to do this automatically? The figures don't have to be numeric,
they can be as text.

Many thanks.