Excel Remove character from import 1

[RITec]

Hi Everyone

I know this should be simple. I am just having one of those moments.

I have some data that was imported into excel and I am trying to remove the ' that is in front of the numbers.

I think this means that it is formated as text but, when I try to format it as a number Still does not work.

I tried to remove the format on that colomn and I get a green triangle in the top left hand corner.

I copied and pasted it into find and replace box and tried to replace it with nothing and it tells me that it can not find that character.

Thank you in advance for helping.

I have over 9000 records



Ritec

 

[bluedragon2]

lets say the data is in col A, in B1 put =value(a1) and copy down. This will put the value of the number in col B. Now copy col b and paste/special/values to col C and now you have numbers.



Blue

If I wasn't Blue, I would just be a Dragon...

 

[RITec]

Thank you bludragon2 that worked great I also found that I could
1.In an empty cell, enter the number 1.
2. Select the cell, and on the Edit menu, click Copy.
3. Select the range of numbers stored as text you want to convert.
3. On the Edit menu, click Paste Special.
4. Under Operation, click Multiply.

Click OK.
Delete the content of the cell entered in the first step

Thank you again for responding so fast

Ritec

 

[bluedragon2]

Yeap, that one works too, keep forgetting about it though...my mind gets slower as the days go on...



Blue

If I wasn't Blue, I would just be a Dragon...

 

[RITec]

I know that feeling

Ritec