Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
MS Office 2003
I have the following filter in a MS ACCESS 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |