LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default query only returns numeric - can I get characters ... ?

I put a space in front of these fields to make them as text.

Haji


"Hajime Kusakabe" wrote in message
...
Excel query returns numeric only from a column that contains numeric and
text.
The column (cells) is fomated as text.

Is there a way to return all the data from the column by query?

Thanks.
Haji



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract first numeric characters only??... KLZA Excel Discussion (Misc queries) 7 March 5th 09 03:59 PM
Omit points from plot if cell is formula returns a non-numeric res Dave Charts and Charting in Excel 2 April 19th 07 03:40 PM
Lost ability to enter Carriage Returns using numeric keypad RichardSchollar Excel Discussion (Misc queries) 3 January 22nd 07 06:36 PM
Removing Non-Numeric Characters GlenS Excel Discussion (Misc queries) 5 October 12th 05 10:50 AM
Deleting non numeric characters. CyndyG Excel Programming 2 May 4th 05 10:50 PM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"