Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported / copied data from SAP
I've been working with Excel spreadsheet data created from SAP and I've
noticed that number values can't be used as-is. Also, when I try and write an equation (ex =9*9) in one of the cells of the imported data, it doesn't calcuate it, it just shows =9*9. The only way I can get number values to calculate properly is by going into each cell and hitting enter. Is there some type of formating change I can make to correct this problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported / copied data from SAP
It sounds as if you've probably got text, instead of numbers, in your cells.
This may be because you've got spaces or non-breaking spaces, or other non-numeric characters in the cells. If they are leading or trailing spaces, the TRIM function should remove them. Otherwise you might need SUBSTITUTE once you've found what the stray characters are. Subsequently you may be able to change text to numbers by either copying a blank cell & then using Edit/ Paste Special/ Add on your range of text numbers (or copying 1 and using Paste Special/ Multiply). Another option is Data/ Text to columns. Your =9*9 is showing that way because the cell is formatted as Text. Format the cell as Number or General then re-enter the formula. F2 and enter should do the trick. -- David Biddulph "Office Pro 2003 user" <Office Pro 2003 wrote in message ... I've been working with Excel spreadsheet data created from SAP and I've noticed that number values can't be used as-is. Also, when I try and write an equation (ex =9*9) in one of the cells of the imported data, it doesn't calcuate it, it just shows =9*9. The only way I can get number values to calculate properly is by going into each cell and hitting enter. Is there some type of formating change I can make to correct this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied formula produces unexpected copied results | New Users to Excel | |||
Imported data | Excel Discussion (Misc queries) | |||
Imported data | Excel Worksheet Functions | |||
DB4 imported data | Excel Discussion (Misc queries) | |||
How to format imported data | Excel Discussion (Misc queries) |