Want to show... numbers after decimal

[udprocks]

Dear Sir,

i want to show numbers like this..

please help.

 

[Ashhu]

Use increse and decrese decimal option, see image.

 

[udprocks]

Use increse and decrese decimal option, see image.

Hi ashhu

Thanks for your reply but m not abler to do this with this Option can u please take a look from urself, if possible.

 

[Ashhu]

Sorry, you mean you can't see option in excel or you need next complete number ex: 23.43 to read 24?

 

[udprocks]

Sorry, you mean you can't see option in excel or you need next complete number ex: 23.43 to read 24?

Have see that option but he is not giving exact result..

like u said..

23.43 to read 24.

 

[bobhc]

In B2 put this and copy down....=CEILING.MATH(A2)

 

[Somendra Misra]

Hi Jitendra,

Try =CEILING(A2,1) and copy down.

Regards,

 

[udprocks]

In B2 put this and copy down....=CEILING.MATH(A2)

dear sir,

thank you for reply, but i have tried this but not working getting "#name?" error.

 

[udprocks]

Hi Jitendra,

Try =CEILING(A2,1) and copy down.

Regards,

Thank you somendra sir,

its working like i wanted....

 

[bobhc]

@udprocks, Not sure why you are getting the error, see the upload

 

[Somendra Misra]

@bobhc

I think you are doing it in 2013, in 2010 it is giving error.

Regards,

 

[Ashhu]

=ROUNDDOWN(A2,0)+1, will also do i guess
Sorry for late reply

 

[bobhc]

@Somendra Misra

Good day, yes you are right I am using 2013, my apologies to @udprocks


.

 

[bobhc]

@Ashhu your use of your posted rounddown formula will not give the correct out come on whole integers.

 

[Ashhu]

Bob
Sorry for misguidance ..

 

[NARAYANK991]

Hi Jitendra ,

Depending on whether you will have negative data , you might want to look at :

=ROUNDUP(number , 0)

This gives the same results as the CEILING function for positive numbers , but the results for negative numbers are different ; you will have to decide which is more suitable for your purposes.

Narayan

 

[udprocks]

Hi Jitendra ,

Depending on whether you will have negative data , you might want to look at :

=ROUNDUP(number , 0)

This gives the same results as the CEILING function for positive numbers , but the results for negative numbers are different ; you will have to decide which is more suitable for your purposes.

Narayan

Good Morning Sir...

Both are working and nice,

Thank you for support and time,