Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
xs2sandeep
 
Posts: n/a
Default I want to convert a column of hexadecimal numbers to decimal num

0 1
0 2
0 3
0 4
0 5
0 6
0 7
0 8
0 9
0 0A
0 0B
0 0C
0 0D
0 0E
0 0F
0 11
0 12
0 13
0 14
0 15
0 16
0 17
0 18
0 19
0 1A
0 1B
0 1C
0 1D
0 1E
0 1F
1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 0A
1 0B
1 0C
1 0D
1 0E
1 0F
1 11
1 12
1 13
1 14
1 15
1 16
1 17
1 18
1 19
1 1A
1 1B
1 1C
1 1D
1 1E
1 1F
2 1
2 2
2 3
2 4
2 5
2 6
2 7
2 8
2 9
2 0A
2 0B
2 0C
2 0D
2 0E
2 0F
2 11
2 12
2 13
2 14
2 15
2 16
2 17
2 18
2 19
2 1A
2 1B
2 1C
2 1D
2 1E
2 1F
3 1
3 2
3 3
3 4
3 5
3 6
3 7
3 8
3 9
3 0A
3 0B
3 0C
3 0D
3 0E
3 0F
3 11
3 12
3 13
3 14
3 15
3 16
3 17
3 18
3 19
3 1A
3 1B
3 1C
3 1D
3 1E
3 1F
6 1
6 2
6 3
6 4
6 5
6 6
6 7
6 8
6 9
6 0A
6 0B
6 0C
6 0D
6 0E
6 0F
6 11
6 12
6 13
6 14
6 15
6 16
6 17
6 18
6 19
6 1A
6 1B
6 1C
6 1D
6 1E
6 1F
7 1
7 2
7 3
7 4
7 5
7 6
7 7
7 8
7 9
7 0A
7 0B
7 0C
7 0D
7 0E
7 0F
7 11
7 12
7 13
7 14
7 15
7 16
7 17
7 18
7 19
7 1A
7 1B
7 1C
7 1D
7 1E
7 1F
8 1
8 2
8 3
8 4
8 5
8 6
8 7
8 8
8 9
8 0A
8 0B
8 0C
8 0D
8 0E
8 0F
8 11
8 12
8 13
8 14
8 15
8 16
8 17
8 18
8 19
8 1A
8 1B
8 1C
8 1D
8 1E
8 1F
9 1
9 2
9 3
9 4
9 5
9 6
9 7
9 8
9 9
9 0A
9 0B
9 0C
9 0D
9 0E
9 0F
9 11
9 12
9 13
9 14
9 15
9 16
9 17
9 18
9 19
9 1A
9 1B
9 1C
9 1D
9 1E
9 1F
0A 1
0A 2
0A 3
0A 4
0A 5
0A 6
0A 7
0A 8
0A 9
0A 0A
0A 0B
0A 0C
0A 0D
0A 0E
0A 0F
0A 11
0A 12
0A 13
0A 14

  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default I want to convert a column of hexadecimal numbers to decimal num

Use the HEX2DEC function.
It is an Analysis Toolpak function, so if you get a #NAME error: ToolsAdd-ins, check Anaysis Toolpak

--
Kind regards,

Niek Otten

"xs2sandeep" wrote in message ...
0 1
0 2
0 3
0 4
0 5
0 6
0 7
0 8
0 9
0 0A
0 0B
0 0C
0 0D
0 0E
0 0F
0 11
0 12
0 13
0 14
0 15
0 16
0 17
0 18
0 19
0 1A
0 1B
0 1C
0 1D
0 1E
0 1F
1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 0A
1 0B
1 0C
1 0D
1 0E
1 0F
1 11
1 12
1 13
1 14
1 15
1 16
1 17
1 18
1 19
1 1A
1 1B
1 1C
1 1D
1 1E
1 1F
2 1
2 2
2 3
2 4
2 5
2 6
2 7
2 8
2 9
2 0A
2 0B
2 0C
2 0D
2 0E
2 0F
2 11
2 12
2 13
2 14
2 15
2 16
2 17
2 18
2 19
2 1A
2 1B
2 1C
2 1D
2 1E
2 1F
3 1
3 2
3 3
3 4
3 5
3 6
3 7
3 8
3 9
3 0A
3 0B
3 0C
3 0D
3 0E
3 0F
3 11
3 12
3 13
3 14
3 15
3 16
3 17
3 18
3 19
3 1A
3 1B
3 1C
3 1D
3 1E
3 1F
6 1
6 2
6 3
6 4
6 5
6 6
6 7
6 8
6 9
6 0A
6 0B
6 0C
6 0D
6 0E
6 0F
6 11
6 12
6 13
6 14
6 15
6 16
6 17
6 18
6 19
6 1A
6 1B
6 1C
6 1D
6 1E
6 1F
7 1
7 2
7 3
7 4
7 5
7 6
7 7
7 8
7 9
7 0A
7 0B
7 0C
7 0D
7 0E
7 0F
7 11
7 12
7 13
7 14
7 15
7 16
7 17
7 18
7 19
7 1A
7 1B
7 1C
7 1D
7 1E
7 1F
8 1
8 2
8 3
8 4
8 5
8 6
8 7
8 8
8 9
8 0A
8 0B
8 0C
8 0D
8 0E
8 0F
8 11
8 12
8 13
8 14
8 15
8 16
8 17
8 18
8 19
8 1A
8 1B
8 1C
8 1D
8 1E
8 1F
9 1
9 2
9 3
9 4
9 5
9 6
9 7
9 8
9 9
9 0A
9 0B
9 0C
9 0D
9 0E
9 0F
9 11
9 12
9 13
9 14
9 15
9 16
9 17
9 18
9 19
9 1A
9 1B
9 1C
9 1D
9 1E
9 1F
0A 1
0A 2
0A 3
0A 4
0A 5
0A 6
0A 7
0A 8
0A 9
0A 0A
0A 0B
0A 0C
0A 0D
0A 0E
0A 0F
0A 11
0A 12
0A 13
0A 14



  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default I want to convert a column of hexadecimal numbers to decimal num

Use HEX2DEC()

It converts a hexadecimal number to decimal.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


--
Gary''s Student


"xs2sandeep" wrote:

0 1
0 2
0 3
0 4
0 5
0 6
0 7
0 8
0 9
0 0A
0 0B
0 0C
0 0D
0 0E
0 0F
0 11
0 12
0 13
0 14
0 15
0 16
0 17
0 18
0 19
0 1A
0 1B
0 1C
0 1D
0 1E
0 1F
1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 0A
1 0B
1 0C
1 0D
1 0E
1 0F
1 11
1 12
1 13
1 14
1 15
1 16
1 17
1 18
1 19
1 1A
1 1B
1 1C
1 1D
1 1E
1 1F
2 1
2 2
2 3
2 4
2 5
2 6
2 7
2 8
2 9
2 0A
2 0B
2 0C
2 0D
2 0E
2 0F
2 11
2 12
2 13
2 14
2 15
2 16
2 17
2 18
2 19
2 1A
2 1B
2 1C
2 1D
2 1E
2 1F
3 1
3 2
3 3
3 4
3 5
3 6
3 7
3 8
3 9
3 0A
3 0B
3 0C
3 0D
3 0E
3 0F
3 11
3 12
3 13
3 14
3 15
3 16
3 17
3 18
3 19
3 1A
3 1B
3 1C
3 1D
3 1E
3 1F
6 1
6 2
6 3
6 4
6 5
6 6
6 7
6 8
6 9
6 0A
6 0B
6 0C
6 0D
6 0E
6 0F
6 11
6 12
6 13
6 14
6 15
6 16
6 17
6 18
6 19
6 1A
6 1B
6 1C
6 1D
6 1E
6 1F
7 1
7 2
7 3
7 4
7 5
7 6
7 7
7 8
7 9
7 0A
7 0B
7 0C
7 0D
7 0E
7 0F
7 11
7 12
7 13
7 14
7 15
7 16
7 17
7 18
7 19
7 1A
7 1B
7 1C
7 1D
7 1E
7 1F
8 1
8 2
8 3
8 4
8 5
8 6
8 7
8 8
8 9
8 0A
8 0B
8 0C
8 0D
8 0E
8 0F
8 11
8 12
8 13
8 14
8 15
8 16
8 17
8 18
8 19
8 1A
8 1B
8 1C
8 1D
8 1E
8 1F
9 1
9 2
9 3
9 4
9 5
9 6
9 7
9 8
9 9
9 0A
9 0B
9 0C
9 0D
9 0E
9 0F
9 11
9 12
9 13
9 14
9 15
9 16
9 17
9 18
9 19
9 1A
9 1B
9 1C
9 1D
9 1E
9 1F
0A 1
0A 2
0A 3
0A 4
0A 5
0A 6
0A 7
0A 8
0A 9
0A 0A
0A 0B
0A 0C
0A 0D
0A 0E
0A 0F
0A 11
0A 12
0A 13
0A 14

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to convert decimal numbers to words Akbar Excel Worksheet Functions 2 January 19th 06 09:40 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
How do I sum hours in Excel and convert to decimal numbers? Heinsohn Excel Discussion (Misc queries) 2 March 5th 05 07:48 PM
How do I indent a decimal aligned column from the margin? ChSp Excel Discussion (Misc queries) 1 December 1st 04 06:33 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"