Skip to main content

Conas ainm 1-12 a thiontú go Excel?

Samhlaigh go bhfuil tuairisc díolacháin díreach faighte agat ina bhfuil na míonna liostaithe mar uimhreacha ó 1 go 12, agus ní mór duit iad a thaispeáint mar ainmneacha míosa comhfhreagracha, mar a léirítear sa screenshot thíos. Ag smaoineamh conas é seo a bhaint amach? San Airteagal seo, déanfaimid tú a threorú trí dhá mhodh éifeachtacha chun uimhreacha mí a thiontú go hainmneacha míonna gan uaim.

Tiontaigh uimhir mhí go ainm na míosa le feidhm TEXT

I ndáiríre, is féidir linn an TÉACS feidhm chun uimhreacha mí (ó 1 go 12) a thiontú go hainmneacha mí go héasca in Excel. Déan mar seo a leanas le do thoil:

  1. Roghnaigh cill bhán inar mian leat ainm na míosa a thaispeáint, mar shampla, cill C2 inár sampla, agus clóscríobh an fhoirmle seo a leanas: 
    =TEXT(A2*29,"mmm")
    Leid: Is é A2 an chéad chill sa liosta Míosa a thosóidh tú ag tiontú uimhreacha mí go hainmneacha mí.
  2. Tarraing hanla líonta na cille foirmle síos chun an fhoirmle a chur i bhfeidhm faoi bhun na gcealla.

Nóta: Chun uimhreacha a thiontú ina n-ainmneacha míosa iomlána, mar "Eanáir," "Feabhra," in ionad giorrúcháin, bheadh ​​ort foirmle eile a úsáid: 
=TEXT(A2*29,"mmmm")

Tiontaigh uimhir mhí go ainm míosa le Kutools le haghaidh Excel

Sa sampla thuas, tá sé soiléir go bhfuil an TÉACS Is fearr an fheidhm atá le hainmneacha mí a chruthú, ach déanann sé amhlaidh i gcill nua ar leith. Dóibh siúd a bhfuil Kutools le haghaidh Excel ar fáil dóibh, tá cur chuige níos simplí fós. Trí úsáid a bhaint as an Oibríocht gné i Kutools, is féidir leat na huimhreacha mí (idir 1 go 12) a chur in ionad go díreach leis na hainmneacha míosa comhfhreagracha.

Kutools le haghaidh Excel - Pacáilte le breis agus 300 uirlis riachtanach le haghaidh Excel. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Íoslódáil anois!

  1. Roghnaigh na huimhreacha a thiontóidh tú chuig a n-ainmneacha míosa comhfhreagracha.
  2. Ar an Kutools tab, sa Eagarthóireacht grúpa, roghnaigh níos mó > Oibríocht.
    Leid: Ag brath ar do shocruithe taispeána, beidh an Oibríocht d'fhéadfadh go mbeadh an t-ordú le feiceáil go díreach laistigh den Eagarthóireacht ghrúpa.
  3. sa Uirlisí Oibríochta bosca dialóige, déan mar a leanas le do thoil:
    1. Roghnaigh an An Chustaim rogha sa Oibríocht bosca.
    2. Clóscríobh an fhoirmle =TEXT(?*29,"mmm") sa An Chustaim bosca. Leid: Ionadaigh "mmm" le "mmmm" san fhoirmle más mian leat ainm iomlán na míosa a thaispeáint in ionad an ghiorrúcháin trí litir.
    3. (Roghnach) Seiceáil an Cruthaigh foirmlí rogha. Leid: Seiceáil an rogha seo más mian leat an fhoirmle a bheith le feiceáil sna cealla. Mura roghnaíonn tú an rogha seo, ní thaispeánfaidh na cealla ach torthaí deiridh na foirmle.
    4. cliceáil Ok.

Toradh

Anois tabharfaidh tú faoi deara go bhfuil na huimhreacha roghnaithe in ionad na míosa go díreach. Féach ar an scáileán:

Nóta: Ag iarraidh rochtain a fháil ar an Oibríocht fóntais? Íosluchtaigh Kutools le haghaidh Excel anois! Thairis sin, tá an iliomad gnéithe eile ag Kutools 300 + agus cuireann sé triail saor in aisce 30-lá ar fáil. Ná fan, bain triail as inniu!

Físeán: Conas ainm 1-12 mhí a thiontú in Excel?

Earraí gaolmhara:

Conas dáta a thiontú go hainm i rith na seachtaine nó ainm míosa in Excel?

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (16)
Rated 4.5 out of 5 · 2 ratings
Joacim
Joacim
This comment was minimized by the moderator on the site
I get the same issue, the only return is "00" regardless of using *28 or *29 in the formula. A column only includes numbers 1-12 so and are in text format, so I can't figure out the issue.
Reply
0
0
Amanda Lee
Amanda Lee     Joacim
This comment was minimized by the moderator on the site
Hi there,

Can you show me a screenshot of your data?
Note: Please select the cell where you entered the formula and then take a screenshot that includes both your data and the formula bar.

Amanda
Reply
Report
0
0
Heike
Heike
This comment was minimized by the moderator on the site
For some reason neither the TEXT formula (=TEXT(cell reference;"mmmm")) nor setting the custom cell format to mmmm is working - both simply return the value "00". Any ideas why this is happening? Simply using the MONTH formula returns the correct month number, so the problem can't be the format of the date.
Reply
0
0
Amanda Lee
Amanda Lee     Heike
This comment was minimized by the moderator on the site
Hi there,

I think the formula in the tutorial is =TEXT(A2*29,"mmm"). And A2 in the formula is the number, say, 2, that you want to convert it to the month text, say, February.

Amanda
Reply
Report
0
0
Learning
Learning
This comment was minimized by the moderator on the site
is there a way to do the kutools example above without getting the extension? For example I type number 1 - 12 on a cell and it automatically changes to a month name?
Reply
0
0
MOULI
MOULI
This comment was minimized by the moderator on the site
Can you explain why is number 29 in this formula ?
Reply
0
0
Rated 4.5 out of 5
Amanda Lee
Amanda Lee     MOULI
This comment was minimized by the moderator on the site
You could also use 28 instead of 29 with the same results.
30 will fail for February and 27 will fail for December, so the only options are 28 and 29
John #30837
30 should fail for February but doesn't because Excel incorrectly assumes that 1900 was a leap year.
27 actually fails for September, October, November and December
Chris #30838

Hi, the above two comments from the page should explain the reason.
If you have other questions, please don't hesitate to ask. :)

Amanda
Reply
Report
0
0
Subodh
Subodh     Amanda Lee
This comment was minimized by the moderator on the site
Principle works. 29 produces error if you have more than few years. 30.4167 works for more than 10 years.
Reply
0
0
antonasf
antonasf
This comment was minimized by the moderator on the site
Coba ini..


=TEXT( "1/" & A2 & "/2022 " ; "m mm mmm mmmm" )


Keterangan :
"1/" dibuat per tanggal 1
A2 cell angka bulan 1 - 12
"/2022" dibuat per tahun 2022
"m mm mmm mmmm" untuk memilih format.

Nanti hasilnya 4 04 Apr April
Reply
0
0
Rated 4.5 out of 5
Amanda Lee
Amanda Lee     antonasf
This comment was minimized by the moderator on the site
Hi, are you tring to have a list of dates in format: day/month/year?
If so, you can just use a formula like this: ="1/"&A2&"/2022".

Amanda
Reply
Report
0
0
Juan Duhalde
Juan Duhalde
This comment was minimized by the moderator on the site
Gracias, me sirvio mucho tu explicación.
Reply
0
0
Tom
Tom
This comment was minimized by the moderator on the site
Very helpful! Thanks so much!
Reply
0
0
Hoang Quyen
Hoang Quyen
This comment was minimized by the moderator on the site
Can you explain why is number 29 in this formula ?
Reply
0
0
asd
asd     Hoang Quyen
This comment was minimized by the moderator on the site
The text formula treats the number as a day in the year. So 1 would be 1st of January, and 365 would be 31st December. If you convert these numbers to months then 1 would be January and 365 would be December. With 2, the formula would see this as 2nd of January so would still return as January. However, with the 29, we can make this 2 58 instead, which alludes to Feb 27th. The formula will thus return this as feb. The same is applied for the numbers 1 to 12. Hope this helps
Reply
0
0
John
John     asd
This comment was minimized by the moderator on the site
You could also use 28 instead of 29 with the same results.

30 will fail for February and 27 will fail for December, so the only options are 28 and 29
Reply
0
0
Chris
Chris     John
This comment was minimized by the moderator on the site
30 should fail for February but doesn't because Excel incorrectly assumes that 1900 was a leap year.
27 actually fails for September, October, November and December
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations