Change the Number format

[sampath]

Hello,

Once i put the number 268 or 15789, which is automatically changed like 2.68 or 157.89.

even check the format cell option also. but cannot change this thing. kindly solve this problem.

Regards,
Sampath.S

 

[NARAYANK991]

Hi Sampath ,

Under Excel Options , Advanced , there is a setting :

Automatically insert a decimal point

Uncheck this checkbox.

Narayan

 

[sampath]

Hi Narayank991.

Thanks for your prompt reply.