03-26-2011 08:45 AM
I have an excel spreadsheet from which I am importing some information into ACT. In the excel sheet the field reads like this: 168.55%, but when I import it it looks like this: 168.5
I would like the % sign to show up in ACT. In fact I have done it before so many of my other records have the % sign in there so I know it can be done, just don't know what I am doing differently now. I have the field formatted as "Character" No need to format as decimal as 2 decimal places is plenty for this type of info.
03-26-2011 09:41 AM
03-28-2011 08:04 AM
There is no such thing as "character" in excel. I assume you mean text as the only options in excel are : General, number, currency, accounting, date, time, percentage, fraction, scientific, text, special & custom.
Tried both suggestions, neither one worked.
Originally in excel the cell was formatted as a "percentage" to 2 decimal places. I tried to change it to "Text" and also tried entering it as text with 2 percentage symbols. The result after importing to act was the same "168.55"
Any other suggestions?