format entry as ###.##

[Guest]

I want a excel format in a cell in this way

for example i enter a number as 123456, then it should automatically be
1234.56.

i have used a formula to do that. but i need a format to do that.

please help

 

[Niek Otten]

Tools>Options>Edit tab, check Fixed decimal for 2 decimals

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want a excel format in a cell in this way
|
| for example i enter a number as 123456, then it should automatically be
| 1234.56.
|
| i have used a formula to do that. but i need a format to do that.
|
| please help
| --
| Varun Nair
|

 

[Bob Phillips]

Tools>Options>Edit, check the Fixed decimal box, and set the number to 2.

Beware, it applies to the application.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)