How to copy and paste without loosing the format?

[Eloise T]

I didn't think this was worthy for the "Ask an Excel Question" forum so that's why it's here in the Lounge.
Please refer to this link:

News | Reade

Stay updated with Reade Advanced Materials' latest news, including certifications, sustainability initiatives, product launches, and industry insights. Discover how we’re advancing material science across aerospace, healthcare, defense, and more.

www.reade.com

I would like to copy the "Fractions" column from this link to an Excel spreadsheet without losing the format. When I try, some fractions copy ok and the others are mistaken for a date.

 

[Fluff13]

Format Column A as text & then right click paste special & select text. Works for me

 

[Fluff13]

Alternatively just put =(ROW()-1)/64 in A2 & fill down as far as needed & format as fraction, Up to 2 digits

 

[GraH - Guido]

Or import via Power Query?

 

[Eloise T]

MANY THANKS to both Fluff13 and GraH - Guido!

 

[Fluff13]

You're welcome & thanks for the feedback