Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format from Access to Excel is busted...help...
I export a file from Access and go into Excel to manipulate the .xls
For some reason the fields are not numbers. I choose the formatting, and manipulate it, but still it's not a recognized number. I hit the sigma for AutoSum and even autosum does not recognize as numbers, and if I do a =sum(range:range) I get 0.0000 in the format I chose for the column. The only way to activate the number as a number is to click it in the value bar, and it will show up in the auto sum. I have 48 tabs full of these numbers, need help with it! Thanks |
#2
|
|||
|
|||
Format the range as numbers or general, select an empty cell, copy it, select
the text numbers and do editpaste special and select add Regards, Peo Sjoblom "NorbyAngell" wrote: I export a file from Access and go into Excel to manipulate the .xls For some reason the fields are not numbers. I choose the formatting, and manipulate it, but still it's not a recognized number. I hit the sigma for AutoSum and even autosum does not recognize as numbers, and if I do a =sum(range:range) I get 0.0000 in the format I chose for the column. The only way to activate the number as a number is to click it in the value bar, and it will show up in the auto sum. I have 48 tabs full of these numbers, need help with it! Thanks |
#3
|
|||
|
|||
Hi Norby
They're coming out of Access as text. The proper thing to do woud be to change in Access from text to number, and run the queries again. The only other thing you can do is to reformat them in Excel from text to number. But this is a bit tricky. Once you have cell formatted as text, it's dificult to reformat it back to number. I'm sure I've seen how to do it somewhere in this forum, but I can't remember the formula to use. I'll post it if I find it. Barb "NorbyAngell" wrote: I export a file from Access and go into Excel to manipulate the .xls For some reason the fields are not numbers. I choose the formatting, and manipulate it, but still it's not a recognized number. I hit the sigma for AutoSum and even autosum does not recognize as numbers, and if I do a =sum(range:range) I get 0.0000 in the format I chose for the column. The only way to activate the number as a number is to click it in the value bar, and it will show up in the auto sum. I have 48 tabs full of these numbers, need help with it! Thanks |
#4
|
|||
|
|||
Peo,
ROCK ON! That was excellent and works quicker than my other solution of a MACRO to select each cell. Thanks, NA "Peo Sjoblom" wrote: Format the range as numbers or general, select an empty cell, copy it, select the text numbers and do editpaste special and select add Regards, Peo Sjoblom "NorbyAngell" wrote: I export a file from Access and go into Excel to manipulate the .xls For some reason the fields are not numbers. I choose the formatting, and manipulate it, but still it's not a recognized number. I hit the sigma for AutoSum and even autosum does not recognize as numbers, and if I do a =sum(range:range) I get 0.0000 in the format I chose for the column. The only way to activate the number as a number is to click it in the value bar, and it will show up in the auto sum. I have 48 tabs full of these numbers, need help with it! Thanks |
#5
|
|||
|
|||
Thanks for the feedback
Peo "NorbyAngell" wrote: Peo, ROCK ON! That was excellent and works quicker than my other solution of a MACRO to select each cell. Thanks, NA "Peo Sjoblom" wrote: Format the range as numbers or general, select an empty cell, copy it, select the text numbers and do editpaste special and select add Regards, Peo Sjoblom "NorbyAngell" wrote: I export a file from Access and go into Excel to manipulate the .xls For some reason the fields are not numbers. I choose the formatting, and manipulate it, but still it's not a recognized number. I hit the sigma for AutoSum and even autosum does not recognize as numbers, and if I do a =sum(range:range) I get 0.0000 in the format I chose for the column. The only way to activate the number as a number is to click it in the value bar, and it will show up in the auto sum. I have 48 tabs full of these numbers, need help with it! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are the Edit, Insert and Format menus greyed out in Excel? | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Access -> Excel: How to export fields > 255 characters | Excel Discussion (Misc queries) | |||
excel front end to access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) |