View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AB[_2_] AB[_2_] is offline
external usenet poster
 
Posts: 236
Default Open file and set numbers of decimal points

Perhaps i'm oversimplifying things but how about formatting the cell
to 2 decimals?
right clickformat cellsNumberNumberDecimal Places=1
?
Bear in mind that this would affect only the way you 'see' the value
while the value will still as it was.


On Mar 15, 9:24*am, BlackSun wrote:
Hi,
I have a problem: if I open an xls file (2003) the numbers are, by
default, shown with 2 decimal point (eg: 189,47).
If I want to see then with only 1 decimal point (189,5) how can I do?
I can't use VBA :(

Thanks in advance

Cheers BlackSun