ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell Display (https://www.excelbanter.com/excel-programming/454375-cell-display.html)

Akash Maheshwari

Cell Display
 
Dear Team,

Greetings!!

In few cells I have mentioned few figures in respective cells.

2450000
8590000
9590000
6590000

What I want is it should be showcase as below in respective cells:

i.e. instea od 2450000 it should be 24.50
i.e. instea od 8590000 it should be 85.90
i.e. instea od 9590000 it should be 95.90
i.e. instea od 6590000 it should be 65.90

Can anyone help me how to do it.

Rgds

Akash Maheshwari


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com