Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
It would be helpful if you gave us 3 or 4 examples of what you see in the
cells best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "shep" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
Hi Shep,
One simple solution is to replace the " " with "x" so your numbers show as 20x30. If you know that your numbers are alway 2 digits then you could run them together and just leave out the " " altogether. When in Excel you could format them 00 00. You could bring them into Excel as two separate fields and then concatenate them in Excel. But these are all suggestions based on insufficient info. I am not clear what you are doing with the 20 30 numbers when they come into Excel, nor whether they are always 2 x 2 digits. -- Cheers, Shane Devenshire "shep" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
Thanks for your responses
Here is report ACCESS produces: # Range 17 10 20 37 20 30 27 30 40 19 40 50 25 50 60 32 60 70 48 70 80 35 80 90 15 90 100 5 100 110 4 120 130 1 130 140 Here is how it shows when analyzed with Excel: Text13 CountOfRange 10/20/2008 17 20 30 37 30 40 27 40 50 19 50 60 25 60 70 32 70 80 48 80 90 35 90 100 15 100 110 5 120 130 4 130 140 1 I know that I can insert a symbol in the query that will cause Excel to show numbers vice date, but I don't want the symbol on graph. Neither do I want user to have to manipulate the Excel data. I may have to yield on one, but that is basis for my request. "ShaneDevenshire" wrote: Hi Shep, One simple solution is to replace the " " with "x" so your numbers show as 20x30. If you know that your numbers are alway 2 digits then you could run them together and just leave out the " " altogether. When in Excel you could format them 00 00. You could bring them into Excel as two separate fields and then concatenate them in Excel. But these are all suggestions based on insufficient info. I am not clear what you are doing with the 20 30 numbers when they come into Excel, nor whether they are always 2 x 2 digits. -- Cheers, Shane Devenshire "shep" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |