Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by mrong
at 2024-07-14 04:36:32
ModifyPoint:500 Replies:14 POST_ID:828974USER_ID:11511
Topic:
Microsoft Excel Spreadsheet Software;;VB Script
Greetings,
I have the format in a same column of 'dd-mm-yyyy' and 'dd/mm/yyyy' in a csv file.
How to format it all to dd-mm-yyyy format?
Thanks.
I have the format in a same column of 'dd-mm-yyyy' and 'dd/mm/yyyy' in a csv file.
How to format it all to dd-mm-yyyy format?
Thanks.
Expert: duncanb7 replied at 2024-07-15 04:36:56
Thanks for your points
Have a nice day
Duncan
Have a nice day
Duncan
Author: mrong replied at 2024-07-14 10:37:32
Sorry, too early to say.
That fixes the issue.
That fixes the issue.
Author: mrong replied at 2024-07-14 10:36:09
it still show dd-mm-yyyy for some records.
Accepted Solution
Expert: duncanb7 replied at 2024-07-14 06:15:43
500 points EXCELLENT
how about you type mm-dd-yyyy into the box
What is diffferent result when type dd-mm-yyy and mm-dd-yyyy
Two tests, try it , work around, you will get it
Duncan
What is diffferent result when type dd-mm-yyy and mm-dd-yyyy
Two tests, try it , work around, you will get it
Duncan
Author: mrong replied at 2024-07-14 06:06:26
Duncan,
Yes, I did exactly same as you suggest but it shows format of 'mm-dd-yyy' format.
Yes, I did exactly same as you suggest but it shows format of 'mm-dd-yyy' format.
Expert: duncanb7 replied at 2024-07-14 05:59:38
check at the image once you press ctrl+1 kry ( ctrl with 1)
http://officeimg.vo.msecnd.net/en-001/files/678/453/ZA102841669.jpg
At Categroy, there is item such as number, date.....custom
and At the "Type", type dd-mm-yyyy
Be remined select the cell or range you want first
Duncan
http://officeimg.vo.msecnd.net/en-001/files/678/453/ZA102841669.jpg
At Categroy, there is item such as number, date.....custom
and At the "Type", type dd-mm-yyyy
Be remined select the cell or range you want first
Duncan
Author: mrong replied at 2024-07-14 05:51:45
duncanb7,
I don't see custom item at the bottom of the left-hand-side-menu.
I use office 2013.
I don't see custom item at the bottom of the left-hand-side-menu.
I use office 2013.
Expert: duncanb7 replied at 2024-07-14 05:03:36
type dd-mm-yyyy in the input box at Category after clicking custom
Be reminded, work around , you will get it
Duncan
Be reminded, work around , you will get it
Duncan
Expert: Guy Hengel [angelIII / a3] replied at 2024-07-14 05:02:59
working with excel to "fix" csv data is not the best tool for the job.
first of all: where does the data come from... usually the issue should be fixed "at the very first source"
for a one-time job, I would write a small whatever(*) script to change the relevant / into -
(*) could be a vba macro, vbscript, a vb6, C#, php ...
in short: anything that you are comfortable with, to do a quick "read line by line", and do a replace.
in unix worlds, this could be a quick awk script...
first of all: where does the data come from... usually the issue should be fixed "at the very first source"
for a one-time job, I would write a small whatever(*) script to change the relevant / into -
(*) could be a vba macro, vbscript, a vb6, C#, php ...
in short: anything that you are comfortable with, to do a quick "read line by line", and do a replace.
in unix worlds, this could be a quick awk script...
Expert: duncanb7 replied at 2024-07-14 05:00:11
There is custom item at the bottom of the left-hand-side-menu , click it, and
choose dd-mm-yyyy or type dd-mm-yyyy in the input box at Category
Duncan
choose dd-mm-yyyy or type dd-mm-yyyy in the input box at Category
Duncan
Author: mrong replied at 2024-07-14 04:59:22
duncanb7,
Followed the link you provided and it also put data from 'dd/mm/yyyy' to 'mm-dd-yyyy'.
I defined the custom format as 'dd-mm-yyyy'.
thanks.
Followed the link you provided and it also put data from 'dd/mm/yyyy' to 'mm-dd-yyyy'.
I defined the custom format as 'dd-mm-yyyy'.
thanks.
Author: mrong replied at 2024-07-14 04:55:28
MacroShadow,
I tried this at very beginning but it put data from 'dd/mm/yyyy' to 'mm-dd-yyyy'
Thanks.
I tried this at very beginning but it put data from 'dd/mm/yyyy' to 'mm-dd-yyyy'
Thanks.
Expert: duncanb7 replied at 2024-07-14 04:44:04
On Excel Sheet, select the cell or range cell you want, press ctrl+1, select date, choose
the format you want from scrolling the side bar
check at the Microsoft atricle as follows
http://office.microsoft.com/en-001/excel-help/format-a-date-the-way-you-want-HA102809474.aspx
Duncan
the format you want from scrolling the side bar
check at the Microsoft atricle as follows
http://office.microsoft.com/en-001/excel-help/format-a-date-the-way-you-want-HA102809474.aspx
Duncan
Expert: MacroShadow replied at 2024-07-14 04:41:35
Open the file
Select the column
Right click
Cell format
Set the format to dd-mm-yyyy
Select the column
Right click
Cell format
Set the format to dd-mm-yyyy
