RE: Formatting Numbers
From: Paul (Paul_at_discussions.microsoft.com)
Date: 08/19/04
- Next message: carol: "SUMIF works for PProd1 but not BA criteria !!"
- Previous message: derkris: "Need help with formula for calculating age difference"
- In reply to: Frank Kabel: "Formatting Numbers"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 19 Aug 2004 03:41:03 -0700
Thanks Frank, that worked. That's a neat trick that'll remember forever!!
"Frank Kabel" wrote:
> Hi
> try the following:
> - select an empty cell and copy it
> - select your imported data range
> - goto 'Edit - Paste Special' and choose the action 'Add'
>
>
> >-----Original Message-----
> >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
> >.
> >
>
- Next message: carol: "SUMIF works for PProd1 but not BA criteria !!"
- Previous message: derkris: "Need help with formula for calculating age difference"
- In reply to: Frank Kabel: "Formatting Numbers"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
