LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Schneider
 
Posts: n/a
Default 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
 
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
Convert decimal degree (lattitude/longitude) into Degree, Tim Ashcom Excel Discussion (Misc queries) 5 August 17th 05 04:53 PM
Convert PivotTable data into a worksheet list sansk_23 Excel Worksheet Functions 3 May 2nd 05 09:51 AM
CONVERT Function Disappered in Excel Gord Dibben Excel Discussion (Misc queries) 3 April 13th 05 07:59 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 08:24 AM.

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

About Us

"It's about Microsoft Excel"