Excel is Confused

[shep]

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

 

[Jeanette Cunningham]

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

 

[alberto perez]

encantado de conocerles,meencanto vuestro grupo