View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
BlackSun BlackSun is offline
external usenet poster
 
Posts: 8
Default Open file and set numbers of decimal points

Hi,
it's not what I need unfortunately... I need that this action must be
automatic when I open _every_ file in excel.

Thanks again

Cheers BlackSun

On 15 Mar, 10:35, AB wrote:
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.