Pasting into Exel

E

Ed

Hi i was wondering if there is a way to paste somthing
into excel with the format #-# or #-#-# without excel
automatically turning it into a date?
thanks
Ed
 
P

Peo Sjoblom

You can pre-format the cells as text (format>cells>number>text), before you
paste it..
 
G

Guest

IT still doesn't work it will only work for one cell but
if i paste a whole table then it will still paste as a
date!
-----Original Message-----
You can pre-format the cells as text
Click to expand...
(format>cells>number>text), before you
 
P

Peo Sjoblom

Works for me...

Regardless, you could paste into notepad, save the file as txt,
then open it in excel and the text import wizard will open,
click next twice and in step 3 select text under column data format
 
Top