Custom cell formating

[sveinhelge.urdal]

I'm putting in information from into Excel.
All lines are numbered in chapeter numbers that is important to keep.

14.1.0
14.1.1
14.1.2
14.2.0
14.2.1

How can I keep this format in excel? Problem now is that it changes it to date.

 

[vletm]

One possible to do like this
'14.1.0
'14.1.1
'14.1.2
'14.2.0
'14.2.1

 

[Syedali]

Hi,

Keep it in General format.

 

[sveinhelge.urdal]

The information is taken from a database that have no Excel eksport function. Så I mark it on screen and paste into Excel and excel cjanges it to date format. To put ' in front is a lot of work.

 

[vletm]

Så, så, så - this is that 'copy&paste'-case!
Could You copy as 'normal'; like Ctrl+C
and
paste only values; 'Paste Special... values' there is 'shortcut too'.
(of course that 'chapter numbers'-column would be set to 'text'-format.)