Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Gig to Meg
I'm playing around with the CONVERT function, trying to get it to convert a
number from gigabytes to megabytes. It would appear, from the help file, that the function should work like this: =CONVERT(A1,"G","M") The value in A1, for this test, is 10. I get the error "#N/A" in the cell with the formula. Clicking on the error, then the information incon, the error at the top of the list is "Value Not Available Error", which would seem to indicate that the "G" and/or "M" from/to units are not available. I'm on Excel 2003 SP1 and have installed the Analysis ToolPak and even the Analysis TookPak - VBA add-ins. Should these conversion values work? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Gig to Meg
Hi!
Not sure how to do it using Convert.......I think Convert is referring to a base 10 system whe giga = 10^9 = 1,000,000,000 mega = 10^6 = 1,000,000 Using a base 2 system: A1 = 10 =A1*(2^30)/2^20 = 10,240 mb gb = 2^30 = 1,073,741,824 bytes mb = 2^20 = 1,048,576 bytes kb = 2^10 = 1,024 bytes Biff "John Schneider" wrote in message ... I'm playing around with the CONVERT function, trying to get it to convert a number from gigabytes to megabytes. It would appear, from the help file, that the function should work like this: =CONVERT(A1,"G","M") The value in A1, for this test, is 10. I get the error "#N/A" in the cell with the formula. Clicking on the error, then the information incon, the error at the top of the list is "Value Not Available Error", which would seem to indicate that the "G" and/or "M" from/to units are not available. I'm on Excel 2003 SP1 and have installed the Analysis ToolPak and even the Analysis TookPak - VBA add-ins. Should these conversion values work? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Gig to Meg
Why make if complicated:
A1 = 10 (Gb) A2 =A1*2^10 (=10240 Mb) Merry Christmas (the turkey smells great!) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Biff" wrote in message ... Hi! Not sure how to do it using Convert.......I think Convert is referring to a base 10 system whe giga = 10^9 = 1,000,000,000 mega = 10^6 = 1,000,000 Using a base 2 system: A1 = 10 =A1*(2^30)/2^20 = 10,240 mb gb = 2^30 = 1,073,741,824 bytes mb = 2^20 = 1,048,576 bytes kb = 2^10 = 1,024 bytes Biff "John Schneider" wrote in message ... I'm playing around with the CONVERT function, trying to get it to convert a number from gigabytes to megabytes. It would appear, from the help file, that the function should work like this: =CONVERT(A1,"G","M") The value in A1, for this test, is 10. I get the error "#N/A" in the cell with the formula. Clicking on the error, then the information incon, the error at the top of the list is "Value Not Available Error", which would seem to indicate that the "G" and/or "M" from/to units are not available. I'm on Excel 2003 SP1 and have installed the Analysis ToolPak and even the Analysis TookPak - VBA add-ins. Should these conversion values work? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Gig to Meg
Why make if complicated:
It's a bad habit of mine! <g Biff "Bernard Liengme" wrote in message ... Why make if complicated: A1 = 10 (Gb) A2 =A1*2^10 (=10240 Mb) Merry Christmas (the turkey smells great!) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Biff" wrote in message ... Hi! Not sure how to do it using Convert.......I think Convert is referring to a base 10 system whe giga = 10^9 = 1,000,000,000 mega = 10^6 = 1,000,000 Using a base 2 system: A1 = 10 =A1*(2^30)/2^20 = 10,240 mb gb = 2^30 = 1,073,741,824 bytes mb = 2^20 = 1,048,576 bytes kb = 2^10 = 1,024 bytes Biff "John Schneider" wrote in message ... I'm playing around with the CONVERT function, trying to get it to convert a number from gigabytes to megabytes. It would appear, from the help file, that the function should work like this: =CONVERT(A1,"G","M") The value in A1, for this test, is 10. I get the error "#N/A" in the cell with the formula. Clicking on the error, then the information incon, the error at the top of the list is "Value Not Available Error", which would seem to indicate that the "G" and/or "M" from/to units are not available. I'm on Excel 2003 SP1 and have installed the Analysis ToolPak and even the Analysis TookPak - VBA add-ins. Should these conversion values work? Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Gig to Meg
Thanks Biff and Bernard. I don't have a problem doing the conversions the
long way, I was just wondering why the function does not work as advertised in help. John "Biff" wrote: Why make if complicated: It's a bad habit of mine! <g Biff "Bernard Liengme" wrote in message ... Why make if complicated: A1 = 10 (Gb) A2 =A1*2^10 (=10240 Mb) Merry Christmas (the turkey smells great!) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Biff" wrote in message ... Hi! Not sure how to do it using Convert.......I think Convert is referring to a base 10 system whe giga = 10^9 = 1,000,000,000 mega = 10^6 = 1,000,000 Using a base 2 system: A1 = 10 =A1*(2^30)/2^20 = 10,240 mb gb = 2^30 = 1,073,741,824 bytes mb = 2^20 = 1,048,576 bytes kb = 2^10 = 1,024 bytes Biff "John Schneider" wrote in message ... I'm playing around with the CONVERT function, trying to get it to convert a number from gigabytes to megabytes. It would appear, from the help file, that the function should work like this: =CONVERT(A1,"G","M") The value in A1, for this test, is 10. I get the error "#N/A" in the cell with the formula. Clicking on the error, then the information incon, the error at the top of the list is "Value Not Available Error", which would seem to indicate that the "G" and/or "M" from/to units are not available. I'm on Excel 2003 SP1 and have installed the Analysis ToolPak and even the Analysis TookPak - VBA add-ins. Should these conversion values work? Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Gig to Meg
I don't think it's supposed to work that way. Note that the help file say
prefixes (as opposed to units) so it can be used to convert for instance a meter to a mega meter, if you put 1000000 in A1 and use =CONVERT(A1,"m","Mm") it will return 1 -- Regards, Peo Sjoblom (No private emails please) "John Schneider" wrote in message ... Thanks Biff and Bernard. I don't have a problem doing the conversions the long way, I was just wondering why the function does not work as advertised in help. John "Biff" wrote: Why make if complicated: It's a bad habit of mine! <g Biff "Bernard Liengme" wrote in message ... Why make if complicated: A1 = 10 (Gb) A2 =A1*2^10 (=10240 Mb) Merry Christmas (the turkey smells great!) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Biff" wrote in message ... Hi! Not sure how to do it using Convert.......I think Convert is referring to a base 10 system whe giga = 10^9 = 1,000,000,000 mega = 10^6 = 1,000,000 Using a base 2 system: A1 = 10 =A1*(2^30)/2^20 = 10,240 mb gb = 2^30 = 1,073,741,824 bytes mb = 2^20 = 1,048,576 bytes kb = 2^10 = 1,024 bytes Biff "John Schneider" wrote in message ... I'm playing around with the CONVERT function, trying to get it to convert a number from gigabytes to megabytes. It would appear, from the help file, that the function should work like this: =CONVERT(A1,"G","M") The value in A1, for this test, is 10. I get the error "#N/A" in the cell with the formula. Clicking on the error, then the information incon, the error at the top of the list is "Value Not Available Error", which would seem to indicate that the "G" and/or "M" from/to units are not available. I'm on Excel 2003 SP1 and have installed the Analysis ToolPak and even the Analysis TookPak - VBA add-ins. Should these conversion values work? Thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Gig to Meg
Thank yolu Peo! Now I understand.
"Peo Sjoblom" wrote: I don't think it's supposed to work that way. Note that the help file say prefixes (as opposed to units) so it can be used to convert for instance a meter to a mega meter, if you put 1000000 in A1 and use =CONVERT(A1,"m","Mm") it will return 1 -- Regards, Peo Sjoblom (No private emails please) "John Schneider" wrote in message ... Thanks Biff and Bernard. I don't have a problem doing the conversions the long way, I was just wondering why the function does not work as advertised in help. John "Biff" wrote: Why make if complicated: It's a bad habit of mine! <g Biff "Bernard Liengme" wrote in message ... Why make if complicated: A1 = 10 (Gb) A2 =A1*2^10 (=10240 Mb) Merry Christmas (the turkey smells great!) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Biff" wrote in message ... Hi! Not sure how to do it using Convert.......I think Convert is referring to a base 10 system whe giga = 10^9 = 1,000,000,000 mega = 10^6 = 1,000,000 Using a base 2 system: A1 = 10 =A1*(2^30)/2^20 = 10,240 mb gb = 2^30 = 1,073,741,824 bytes mb = 2^20 = 1,048,576 bytes kb = 2^10 = 1,024 bytes Biff "John Schneider" wrote in message ... I'm playing around with the CONVERT function, trying to get it to convert a number from gigabytes to megabytes. It would appear, from the help file, that the function should work like this: =CONVERT(A1,"G","M") The value in A1, for this test, is 10. I get the error "#N/A" in the cell with the formula. Clicking on the error, then the information incon, the error at the top of the list is "Value Not Available Error", which would seem to indicate that the "G" and/or "M" from/to units are not available. I'm on Excel 2003 SP1 and have installed the Analysis ToolPak and even the Analysis TookPak - VBA add-ins. Should these conversion values work? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
Convert PivotTable data into a worksheet list | Excel Worksheet Functions | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |