Hi All ,

In a big range of cells i need to adjust cells as following :
cells with the first decimal after comma greater than 0 to be kept with
decimal while cells with first decimal after comma is equal to 0 should
has no decimal .

Could that be done by the ASAP utilities and how , if not any way for a
macro to do that ?

Thank you very much.


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
View this thread: http://www.excelforum.com/showthread...hreadid=484949

Sounds like you want to round to thousands. Can you give examples of
your data, and how you'd like it to appear?

Supposing i have the following :

A1= 10,50
A2= 7,00
A3= 2,03
A4= 8,00

In a way by selecting the range A1: A4 i need to turn like this :
A1= 10,5
A2= 7
A3= 2
A4=8

Which keeps the first decimal after the comma of each value if it is
greater than 0 and delete what is 0 after the comma.
I would like to mention that by clicking the increasing and decreasing
decimals buttons could not solve it that way , it either keeps them
with 1 or 2 decimals. A rounding formula is not needed neither, it
should be a macro or a utility such ASAP but i dont know if it does
such thing and how ?

Many thanks .


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
View this thread: http://www.excelforum.com/showthread...hreadid=484949