Thread: Cell Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
D D is offline
external usenet poster
 
Posts: 121
Default Cell Format

THANK YOU BARB!

You are good! it worked!!

Have a nice weekend!

Dan



"Barb Reinhardt" wrote:

Hmmm, I know of a way to do it for dates, but I'm not sure it will work in
this application. Save a copy just in case this doesn't work.

Select the column with the "numbers" in it.
Data - Text to Columns - I selected Delimited - I turned off all the
delimiters and set text qualifier to NONE - Next - Set column data format
to General - Finish.
--
HTH,
Barb Reinhardt



"D" wrote:

Hi Barb:

Yes, it is false? Can I do something?

Thanks all!

Dan

"Barb Reinhardt" wrote:

In an adjacent column, put this

=ISNUMBER(A1) where A1 is the address of the cell in question

If it's a number, you'll see TRUE, if it's not, you'll see FALSE. What do
you see?
--
HTH,
Barb Reinhardt



"D" wrote:

Hi:

Can you please tell me what would be the reason that for an Access table
exported to Excel, in one col. I cannot format in any way the numbers? no
calculation works?
They display as numbers, formatted as numbers, but for ex. the sum is 0??

Thanks,

Dan