Formatting Numbers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul (Paul_at_discussions.microsoft.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 02:33:05 -0700

Hi Guys, can anyone help?
I'm importing data from an access database into an Excel spreadsheet. I have
a column that contains numeric and alpha numeric data. I need to be able to
format the numeric data so that it is in number format (currently it imports
in general format). If I change the format of the column to number, nothing
happens until I edit an individual cell. On leaving the cell it is converted
to a number. I have lots of data though so this isn't very practical. Does
anyone know a quick way to do this? Is it causing a problem because I have
mixed numeric and alphanumeric data in the column? I'm happy to change the
format of the alphanumeric data manually as there are only two or three
fields but need the number formats to change in a "one click" time frame due
to the amount of data!!

If anyone can help I'd really appreciated it.

Many thanks
Paul

Relevant Pages

  • Re: Excel importing of csv and xml
    ... You can certainly automate the process - start by recording a macro ... XL imports according to the MS Spreadsheet schema. ... want to import numbers in a different format, ... > comes in as numeric data of 1503 in both formats, ...
    (microsoft.public.excel)
  • Re: MISSING ZERO IN IMPORTED EXCEL DATA 104.10 = 104.1 ????HOW CAN
    ... My VB App converts the numeric data into text because I need to ... >> When importing from Excel (or any other external file format, ... Wherever you want to show the two decimals (or ...
    (microsoft.public.access.externaldata)
  • RE: Formatting Numbers
    ... "Frank Kabel" wrote: ... >>a column that contains numeric and alpha numeric data. ... >>format the numeric data so that it is in number format ... >>happens until I edit an individual cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Concatenate numbers
    ... leading "0" when concatenating the numbers and what settings affect ... should be stored in numeric data types. ... Or using that format pattern with the column command: ... column digits format  0.999999999999999999 ...
    (comp.databases.oracle.misc)
  • Re: how to make text bold in excel using a formula?
    ... > I am importing data from text file, and I dont want to do modify the ... >> use 'Format - Conditional Format' for this ... >>> How can convert text to bold wihtout using a formula. ... >>> The main problem is we are importing data to excel file from a text ...
    (microsoft.public.excel.misc)