View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Open file and set numbers of decimal points


It is possible to create a macro, that you would only have to use one time.
It would open every workbook in every folder and change the "Normal" style for that workbook and
save the workbook.
Once that was done, only brand new workbooks would require a style change before saving.
(no, I am not offering to write it for you)
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Formats & Styles: lists/removes unused styles & number formats - in the free folder)



"BlackSun"
wrote in message
...
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.