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.