Prev: rtggtr
Next: Standard Ribbon Tabs in Access 2007 Runtime
From: shep on 4 Jul 2008 10:42
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


From: Jeanette Cunningham on 4 Jul 2008 19:34
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(a)discussions.microsoft.com> wrote in message
news:F8BF1F22-4FDF-405F-B954-18DCB06020C2(a)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
>
>


From: alberto perez on 4 Jul 2008 19:44
encantado de conocerles,meencanto vuestro grupo

"shep" <shep(a)discussions.microsoft.com> escribió en el mensaje de
noticias:F8BF1F22-4FDF-405F-B954-18DCB06020C2(a)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
>
>
 | 
Pages: 1
Prev: rtggtr
Next: Standard Ribbon Tabs in Access 2007 Runtime