(Msg. 2) Posted: Sat Jul 05, 2008 1:44 am
Post subject: Re: Excel is Confused Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
encantado de conocerles,meencanto vuestro grupo
"shep" <shep.DeleteThis@discussions.microsoft.com> escribió en el mensaje de
noticias:F8BF1F22-4FDF-405F-B954-18DCB06020C2@microsoft.com...
> MS Office 2003
>
> I have the following filter in a query to pull buildings' square feet in
> size ranges in thousands from a range table.
>
> NewRange: Format([Min],"###,") & " " & Format([Max],"###,")
>
> I then move report into Excel to produce graph depicting number of stores
> in
> each ranch.
>
> However, Excel interprets numbers as date format and strangely shows first
> entry in date format and remainder in desired format; e.g., 20 30.
>
> Can filter be coded so Excel interprets output as general number?
>
> Thanks
>
>
(Msg. 3) Posted: Sat Jul 05, 2008 3:00 am
Post subject: Re: Excel is Confused Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
In excel, typing two numbers with a space between is often interpreted as a
date.
The field that has the min and max with a space in between is always going
to be a string data type.
I think you would get a more helpful answer if you asked this in the excel
discussion group.
Jeanette Cunningham -- Melbourne Victoria Australia
"shep" <shep.RemoveThis@discussions.microsoft.com> wrote in message
news:F8BF1F22-4FDF-405F-B954-18DCB06020C2@microsoft.com...
> MS Office 2003
>
> I have the following filter in a query to pull buildings' square feet in
> size ranges in thousands from a range table.
>
> NewRange: Format([Min],"###,") & " " & Format([Max],"###,")
>
> I then move report into Excel to produce graph depicting number of stores
> in
> each ranch.
>
> However, Excel interprets numbers as date format and strangely shows first
> entry in date format and remainder in desired format; e.g., 20 30.
>
> Can filter be coded so Excel interprets output as general number?
>
> Thanks
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other