Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
hi
guessing here but the numbers were probably imported as text. look in the formula bar and see if there is a leading apostrophe with the numbers. if so, you will have to get rid of it. also check access and see how the number column is formated. regards FSt1 "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |