Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save a file with decimal number
Hi,
I try to run macro to save a csv download file with filename as yesterday and a last cell on excel sheet which has formula sum up in column. such as 09-19-$3659.45, SAVE AS normal excel file, but the saved filename display only 09-19-$3659 and without two decimal or with decimal but file icon is not an excel icon. I can't get it work correctly. Can any help on this? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save a file with decimal number
Try adding the .XLS extension..!
eg.. 09-19-$3659.45.XLS HTH "soeo22" wrote in message ... | Hi, | I try to run macro to save a csv download file with filename as yesterday | and a last cell on excel sheet which has formula sum up in column. such as | 09-19-$3659.45, SAVE AS normal excel file, but the saved filename display | only 09-19-$3659 and without two decimal or with decimal but file icon is not | an excel icon. I can't get it work correctly. Can any help on this? | Thanks in advance. | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save a file with decimal number
ActiveWorkbook.SaveAs Filename:="C:\Gordstuff\" & _
Format(Date - 1, "mm-dd-") & _ Format(Sheets("Sheet6").Range("A3"), "$#,##0.00") & ".xls" Gord Dibben MS Excel MVP On Sun, 20 Sep 2009 11:43:01 -0700, soeo22 wrote: Hi, I try to run macro to save a csv download file with filename as yesterday and a last cell on excel sheet which has formula sum up in column. such as 09-19-$3659.45, SAVE AS normal excel file, but the saved filename display only 09-19-$3659 and without two decimal or with decimal but file icon is not an excel icon. I can't get it work correctly. Can any help on this? Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save a file with decimal number
Thank you so much, it works exactly the way I want it.
"Gord Dibben" wrote: ActiveWorkbook.SaveAs Filename:="C:\Gordstuff\" & _ Format(Date - 1, "mm-dd-") & _ Format(Sheets("Sheet6").Range("A3"), "$#,##0.00") & ".xls" Gord Dibben MS Excel MVP On Sun, 20 Sep 2009 11:43:01 -0700, soeo22 wrote: Hi, I try to run macro to save a csv download file with filename as yesterday and a last cell on excel sheet which has formula sum up in column. such as 09-19-$3659.45, SAVE AS normal excel file, but the saved filename display only 09-19-$3659 and without two decimal or with decimal but file icon is not an excel icon. I can't get it work correctly. Can any help on this? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I save an excel file with long number columns in cvs form. | Excel Discussion (Misc queries) | |||
CSV file doesn't save "xEy" style number as text formatted data | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
Save file name with version number | Excel Discussion (Misc queries) | |||
How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions |