Forum Discussion
adjust my data
i have mix data with dates and stock names but i want to adjust my data like what i show in picture. and i have huge amount of data. i just want to adjust my data date wise.
Not sure if I understand your question exactly but I think your saying that you want to format your date to be in the format you're showing on the screenshot if so:
- Hightlight all cells that contain that dates
- Right click --> format cells (or CTRL+1)
- In numbers tab clcik on Custom on the left
- Set your type to DD-MM-YYYY
- Hit ok
Hope this is what you mean 👍