Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Data
I can export from my MRP system into an excel format, but this does it in a
way so that i can't manipulate the data. all the cells have a ' before the value. I've tried deleting the ' but it still doesn't let me reformat......any ideas??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Data
Hi,
Highlight all the data, CTRL + H, find what enter ', then click replace another option in another column enter =trim(A1) then copy this column as value "Gazz_85" wrote: I can export from my MRP system into an excel format, but this does it in a way so that i can't manipulate the data. all the cells have a ' before the value. I've tried deleting the ' but it still doesn't let me reformat......any ideas??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Data
Enter a 1 in some empty cell. Do Edit - Copy on that cell. Select all the
cells you want to change. Do Edit - Paste Special - Multiply. Done. HTH Otto "Gazz_85" wrote in message ... I can export from my MRP system into an excel format, but this does it in a way so that i can't manipulate the data. all the cells have a ' before the value. I've tried deleting the ' but it still doesn't let me reformat......any ideas??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Data
It didn't work???
"Eduardo" wrote: Hi, Highlight all the data, CTRL + H, find what enter ', then click replace another option in another column enter =trim(A1) then copy this column as value "Gazz_85" wrote: I can export from my MRP system into an excel format, but this does it in a way so that i can't manipulate the data. all the cells have a ' before the value. I've tried deleting the ' but it still doesn't let me reformat......any ideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting ALL data labels for ALL data series at once | Charts and Charting in Excel | |||
Formatting data series - line between certain data points only | Charts and Charting in Excel | |||
Formatting Rows of Data based on Column Data | Excel Worksheet Functions | |||
Formatting the data | Excel Discussion (Misc queries) | |||
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) | Excel Discussion (Misc queries) |