View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Govind
 
Posts: n/a
Default Custom Formatting

Hi,

Go to Format cells, Custom format and enter

#,,.0

Regards

Govind.

nastech wrote:
Hi, is there a way to custom format a cell, to read millions (all numbers) to
same as divided by 1 million, with 1 decimal after the period? thanks...

i.e.: 25,052,000 will read 25.1