number display

  • Thread starter Thread starter cord
  • Start date Start date
C

cord

Hello everyone,

This may seem like a basic question, but I am self taught in excel and
just can't figure this one out. I have a figure 4,500,000.00 and I
want to display it in a report as 4.5 (4.5 million instead of showing
all the zeroes) I have looked through all the formats and can't seem
to find anything that will do this for me, does anyone know a way??

Thanks!
 
Back
Top