Maitiro ekushandura Date Format muGoogle Sheets uye Excel Online

kunyange zvazvo Google Sheetsiti uye Excel Pamhepo ndiwo maviri eakanakisa emahara epamhepo epamhepo editing maspredishiti, unogona kusada mamwe maficha awo. Semuenzaniso, iyo date format. Kana iwe usingade kushandisa iyo yakafanotaurwa zuva kana nguva fomati, unogona kuzvishandura muGoogle Sheet uye Excel Online. Kuti uwane ruzivo, haufanire kushandisa yekuwedzera-kana chero imwe yechitatu-bato sevhisi kuti iitwe.

Iko hakuna muganho pane zvaunogona kunyora kana kuisa muExcel spreadsheet. Kubva pakunyora mameseji akareruka kuenda kumufananidzo kusvika nhasi uye nguva, unogona kuwedzera chero chinhu kune yako Excel faira. Paunowedzera zuva, rinoshandisa chimiro chakafanotaurwa. Kunyangwe iwe uchida fomati senge 02/08/2021, Excel Online uye Google Sheets inogona kushandisa chimwe chinhu, senge 08-02-2021. Dzimwe nguva, iwe ungasafarira shanduko yakadaro nekuda kwekusaziva. Mumamiriro ezvinhu akadaro, unogona kutevera gwara iri kushandisa tsika kana zuva rakasiyana kana fomati yenguva muGoogle Sheets uye Excel Online.

Maitiro ekushandura Date Format muGoogle Sheets

Kuti uchinje fomati yemazuva muGoogle Sheets, tevera matanho aya:

  1. Vhura Google Sheets pane browser rako.
  2. Dzvanya pane zuva / nguva sero.
  3. Enda ku Format > Nhamba.
  4. Sarudza iyo Custom zuva uye nguva kuita.
  5. Sarudza chimiro chezuva/nguva.
  6. Baya Shandisa bhatani.

Kuti udzidze zvakawanda nezve nhanho idzi, enderera kuverenga.

Kutanga, iwe unofanirwa kuvhura iyo Google Sheet pabrowser yako. Wobva wadzvanya pasero, iro rinoratidza zuva nenguva.

Mushure meizvozvo, tinya pane iyo urongwa menyu pane yepamusoro menyu bar, uye sarudza iyo nhamba sarudzo. Zvadaro, sarudza iyo Custom zuva uye nguva kuita.

Maitiro ekuchinja zuva fomati muGoogle Sheets uye Excel Online

Pano unogona kuwana runyoro rwemhando dzakasiyana dzezuva nenguva. Iwe unogona kusarudza sarudzo yaunoda uye tinya iyo Shandisa bhatani.

Kana wangopedza, unogona kuwana iyo fomati itsva.

Matanho ataurwa pamusoro anokubatsira kushandura zuva kana nguva fomati yeimwe sero. Nekudaro, kana iwe uchida kushandisa shanduko imwechete kune ese maseru, iwe unofanirwa kusarudza rese spreadsheet kutanga. Mushure maizvozvi, unogona kutevera nzira imwechete sepamusoro.

Maitiro ekushandura Date Format muExcel Online

Kuti uchinje fomati yemazuva muExcel Online, tevera matanho aya:

  1. Vhura Excel Online pakombuta yako.
  2. Tinya kurudyi pane zuva/nguva sero.
  3. Sarudza iyo Nhamba Format kuita.
  4. Tendeukira kune zuva Tab.
  5. Sarudza chimiro chezuva chaunoda.
  6. Baya OK bhatani.

Ngatitarisei matanho aya zvakadzama.

Kuti utange, unofanirwa kuvhura spreadsheet muExcel Online. Wobva wadzvanya-kurudyi pane zuva/nguva sero uye sarudza iyo Nhamba Format sarudzo kubva kumenu yemamiriro.

Kana hwindo ravhurwa, chinja kune iyo zuva tab. Pano iwe unogona kuwana akawanda sarudzo dzemazuva. Iwe unogona kusarudza imwe maererano nezvaunoda.

Zvadaro, chengeta OK bhatani rekuchengetedza shanduko.

Kuti uwane ruzivo, unogona kushanyira iyo nguva tab yekuseta fomati yakajairwa kunguva zvakare. Zvakare, seGoogle Sheets, unogona kushandura fomati yezuva uye nguva yemasero ese kamwechete kana ukasarudza rese spreadsheet kutanga.

Ini ndinogona kushandura iyo date fomati muGoogle Sheets?

Ehe, unogona kushandura iyo date fomati muGoogle Sheets. Nekuda kweizvozvo, iwe unofanirwa kusarudza sero kutanga. Zvadaro, enda ku Format > Nhamba uye sarudza Custom zuva uye nguva sarudzo. Mushure meizvozvo, sarudza fomati yaunoda uye tinya iyo Shandisa bhatani. Kana iwe uchida kuisa shanduko yespredishiti yese, unofanirwa kuisarudza kutanga.

Ini ndinoshandura sei iyo date fomati muExcel 365?

Kuti uchinje fomati yemazuva muExcel 365, sarudza sero muspredishiti rako uye enda ku Format > Fomati Masero. Unogona kuwana iyi sarudzo mu musha tab. Zvadaro, chinja kune zuva tab uye sarudza fomati sekuda kwako. Pakupedzisira, tinya pa OK bhatani rekuchengetedza shanduko.

Article Yepakutanga