How to re-format from '## to just ##?

[beancounter]

Help, I've inherited a worksheet where the previous author used a ' infront of all the numbers. I can't seem to change the format and use the numbers as numbers they can only be used as text. Any suggestions? Thanks

 

[RichardS]

Hi fellow beancounter, welcome to the Board

Enter 1 in a spare cell, copy, select "text" numbers, paste|special, check the multiply radio button.

Richard

_________________

This message was edited by RichardS on 2002-10-31 19:46

 

[PaddyD]

put a zero in a spare cell, select & copy it, select the range of 'text numbers', go to edit | paste special, select add, hit OK.

paddy

 

[phantom1975]

WELCOME TO THE BOARD!

Here is one way to do it. You could create a new worksheet and in cell A1 put the following:

=value(Sheet1!A1)

This would convert the value of cell A1 on Sheet1 to a number. Copy the formula and paste it throughout the new worksheet to the same size as the original worksheet.

Another way to do it would be to copy the area of the original that you want to convert. Then Paste Special.....VALUES.

Take your pick.

 

[beancounter]

Thanks Phantom1975 your second suggestion worked. The other paste special way didn't work and I tried them all.

Thanks again