If you enter 4/10, Excel converts that fraction to a date. Reply JSG says: 2021-04-29 at 10:08 pm hello, how to change the time format using an excel function, example, converting this format (12:00 AM/PM) to (12-00-00 AM/PM), (12:00:00 AM/PM), (12 AM/PM) thanks ...
all, I need some help with a function that I am not able to get working. I am using a Pivot Table to organize a large amount of date that is compiling information from a number of different pipeline sections and giving me a total count of how many units I need / size. I need to...
Sub test() Dim arr() k = 1 Set doc = CreateObject("word.application") '创建Word对象 With Application.FileDialog(msoFileDialogFilePicker) .AllowMultiSelect = True '多选择 .Filters.Clear '清除文件过滤器 .Filters.Add "Word 文件", "*.doc*" .Show For l = 1 To .SelectedItems.Count Set wd...