MS Exel 2003

Nitko niša? Pretpostavljam da nema jednostavnog rješenja za ovaj problem. Probao sam malo na netu, ali ništa.

Ima li netko rješenje?

Na žalost to važi samo kad formatiraš ćeliju prije upisivanja podataka. Ja bih trebao dodati godinu npr.07 na već postojeći datum u ćeliji npr. 10.06.

Našao sam upute u helpu od excela "convert dates stored as text to dates"

Convert text dates by using the DATEVALUE function
First you'll convert the text date in a cell to a serial number by using the DATEVALUE function. Then you'll copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date format to them.

Select a blank cell and verify that its number format is General. 
On the Format menu, click Cells.
Click the Number tab.
In the Category box, make sure that General is selected.
In the blank cell, type =DATEVALUE( , click the cell that contains the text-formatted date that you want to convert, type ), and then press ENTER.
The DATEVALUE function returns the serial number of the date that is represented by the text date.

Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
To copy the conversion formula into a range of contiguous cells, select the cell in which you typed the formula, and then drag the fill handle  across a range of empty cells that matches in size the range of cells that contain text dates.
After you drag the fill handle, you should have a range of cells with serial numbers that corresponds to the range of cells that contain text dates.

Select the cell or range of cells that contains the serial numbers, and then click Copy on the Edit menu.
Select the cell or range of cells that contains the text dates, and then click Paste Special on the Edit menu.
In the Paste Special dialog box, under Paste, click Values, and then click OK.
On the Format menu, click Cells.
On the Number tab, in the Category box, click Date, and then click a date style in the Type box.
Tip   You can now delete the cells that contain the serial numbers.

Dakle, u ćeliji A1 imaš upisano 10.06.

Treba ti funkcija CONCATENATE da "dodaš" godinu. Pa u B1 upiši:

CONCATENATE(A1;2008) rezultat će biti 10.06.2008  (ali to još NEĆE biti datum, već "general format" odn. alfanumerik)

potom ga trebaš pretvoriti u formu datuma sa DATEVALUE(B1)

prvo će ti se pokazati zbunjujući broj  (u našem slučaju 39609) jer Excel računa datume od 1.1.1900 godine

potom desnim klikom odabereš Format cells - Number - Category - Date i odabereš oblik datuma koji želiš te dobiješ:

10.06.2008

Skraćeno:

DATEVALUE(CONCATENATE(A1;2008))

desni kllik - format cells - odabereš oblik datuma

Hvala vam svima, a posebno Aron-u. Spašen sam, tj. spasio si me!

Hvala puno!

Bolje da si otvorio novu temu sa konkretnim naslovom radi budućeg  pretraživanja.

Za brojanje ćelija koristi jednu od slijedećih funkcija

- funkcija COUNT

- funkcija COUNTA

- funkcija COUNTIF

jel bi more tko dati link samo za exel 2003, alil da je na hrv jeziku!!

Inace imam win7, ali office 2010 na hrv!
Treba mi hitno smao exel 2003 na hrv jeziku, za brata, zato kaj uce us kkoli exel jos uvijek na 2003