Excel formatting question

[dmaier]

I often paste stuff into Excel from other sources that have the following format 6-6 and Excel changes to June 6. Is there anyway to change excel so that it doesn't try to reformat the 6-6 to June 6?

 

[jdhilljr]

Format the cell as text.

Jim

 

[maverickmonster]

you can goto past special and check values and that should work or make the cell a general or a custom format of 0-0

 

[dmaier]

Doesn't really work for me

I tried reformatting the cells to text and then pasted and it still comes up wrong.

I tried paste special and using text and it puts everything in one column instead of multiple columns.

 

[xlbo]

Problem is - if you paste then you overwrite formats. If you pastespecial, excelo doesn't recognise that there is delimited data

I would go for pasting special and then using Text To Columns - you should be abloe to RECORd the text to columns procedure using Tools>Macro>Record New Macro so that you can automate it...

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[bluedragon2]

format the cell as custom:

m-d



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[KenWright]

Excel is a right royal pita when it comes to 'helping' you like this. One option you may have is to paste it into Notepad, create a text file and then use the Text import wizard with whatever delimiters you have, specifying that column as text. Roundabout, but if it helps....

Regards
Ken..................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------