| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
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 |
| 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) | |||
Threaded Mode
