Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |