Prev: OR formula, ?????
Next: How to apply Macro on a same type of format but in excess content?
From: Whale on 23 Feb 2010 22:08
I have copied a file which contains some hexadecimal formatted addresses.
However, I haven't been able to keep the same hexadecimal format in excel.
I don't want to convert the data to "text","general number", "scientific",
etc as the value will change and is thus useless to me. Examples are
"002100" changes to "2100", and "001E10" changes to "1E+10". Use converting
to hexadecimal functions do not seem sensible.
How can I keep the format exactly as the original data before importation?
Any ideas. I'm sure there is a simple solution.
From: "David Biddulph" groups [at] on 24 Feb 2010 03:23
If you don't want it to change, you need to import it as text. If you then
want to do arithmetic with the hex values, you need to convert to a number,
with HEX2DEC.
--
David Biddulph


"Whale" <Whale(a)discussions.microsoft.com> wrote in message
news:EAF99AF6-74B7-4817-950A-3B2ED888BA42(a)microsoft.com...
> I have copied a file which contains some hexadecimal formatted addresses.
> However, I haven't been able to keep the same hexadecimal format in excel.
> I don't want to convert the data to "text","general number", "scientific",
> etc as the value will change and is thus useless to me. Examples are
> "002100" changes to "2100", and "001E10" changes to "1E+10". Use
> converting
> to hexadecimal functions do not seem sensible.
> How can I keep the format exactly as the original data before importation?
> Any ideas. I'm sure there is a simple solution.


 | 
Pages: 1
Prev: OR formula, ?????
Next: How to apply Macro on a same type of format but in excess content?