need a hand here
ive got a long list of MAC addresses which im doing Replace all on (to remove the - between each 2 chars) but when i do this a couple of them are going nuts thinking theres calculations in them etc
tried playing around with the cell formatting but i cant seem to find one that doesnt cause me to have 20 0's on the end or something like 1.56E+16 to pop up etc >_<
any help greatly appreciated, im trying to make a WOL script for set machines and its meant to be a simple task which is getting me increasingly annoyed!
ive got a long list of MAC addresses which im doing Replace all on (to remove the - between each 2 chars) but when i do this a couple of them are going nuts thinking theres calculations in them etc
tried playing around with the cell formatting but i cant seem to find one that doesnt cause me to have 20 0's on the end or something like 1.56E+16 to pop up etc >_<
any help greatly appreciated, im trying to make a WOL script for set machines and its meant to be a simple task which is getting me increasingly annoyed!
