Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Downloaded Report
I have a report that I download into excel - it has a currency value and when
I try to do a calculation on it - it will not work. I noticed that the values are not formatted as a number so I changed that. I also noticed there are some extra spaces in the field I tried the clean function, the trim function and convert text to columns to attempt to isolate and remove the extra spaces - none seemed to work. Any other suggestions to get these converted to text so calculations will work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i convert a downloaded template to UK | Excel Discussion (Misc queries) | |||
Updating of Downloaded Spreadsheet | Links and Linking in Excel | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) | |||
downloaded template | Excel Discussion (Misc queries) |