Losing leading zeros when copied to another sheet

[robbo1172]

Hi all

The attached worksheet works well except for one issue I'm hoping someone may be able to help me with.

The Equipment List worksheet contains parts for each individual piece of equipment, and the Parts List worksheet has the parts list for the entire job, all consolidated in one place for ordering.

My problem is that the Weidmuller parts have a 10 digit number with leading zeros (eg row 45 - 0474560000), which I need to keep.

When the worksheet is updated, when copied to the second sheet (Parts List), the leading zeroes are lost (eg row 19 - 474560000 which should be 0474560000).

Could one of you fine folk please take a quick look at it for me?

Many thanks, Robbo

[jeffreybrown]

Format the sheet as text and it should work fine.

[humdingaling]

your not actually copying the range across but replicating it
as such you lose that text formatting you have

Please Login or Register  to view this content.

ps you have a table in parts list worksheet which is causing some issues
maybe get rid of it if your not using it

[robbo1172]

Thanks Jeff, I tried that but the formatting is lost when updating replicating for the parts list.

Thanks Humdingaling, works fine now.

Much appreciated.

[robbo1172]

I've just come across a problem with the spreadsheet as attached by Humdingaling above.

If I update the Equipment List worksheet, the UPDATE button on the Parts List worksheet no longer works.

Any advice would be appreciated.

Robbo

[humdingaling]

change clearcontents back to your entirerow.delete

Please Login or Register  to view this content.

[robbo1172]

Perfect, thanks you.

Robbo