View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edgar[_3_] Edgar[_3_] is offline
external usenet poster
 
Posts: 40
Default Format and Convert

Hi

Frank Kabel kindly helped me earlier with the following
code to save the workbook with a date stamp - it worked
the first time i ran this but keeps failing now with the
following error:

Compile error: Wrong number of arguments or invalid
property assignment!!

I have tried renaming the book before I run the macro but
this doesnt seem to do anything.

Also column L contains the data like the following:
1.6M
0.02M
2.5M

Where M stands for Million, i would like to convert this
to an actual figure - does anyone have any ideas?

TIA