separate data and change text to number

[Alin]

Here's my problem. Column A named Store, Column B Job. Some of the
cells in column A have two stores. I need to separate the stores and
put them all in one column underneath each other. The column needs to
be formated as number.

Store Job Store Job
378 & 349 Sign Package
370 & 383 Sign Package
362 & 368 Sign Package
357 & 367 Sign Package
352 & 359 Arrow Refresh& sign Package
352 & 359 Arrow Refresh& sign Package
8528 sign package
8519 Arrow Refresh& sign package
8472 sign package
8446 sign package
8439 sign package
8437 sign package
8418 Arrow Refresh & Sign Package
6989 Arrow Refresh & Sign Package
6988 Arrow Refresh& sign Package
6985 sign package

Thank for your help

FNG