Software

Ask something
Discussion Locked

Excel Text / Number Format

0 helpful
3 replies

by laurie j

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a spreadsheet that has a column of 10,000 numbers. However, they act like text. I have tried to format these by highlighting the column and trying to format the whole column. This does not work and the only way to alter these is by manually hitting the F2 key and then the Return key on each cell.

Is there a quicker way????

3 replies

by dklippert

Pick an empty cell and enter the number 1.
Copy that number. Select all of the numbers (Ctrl+Shift+ Down arrow) and choose Edit>Paste Special Multiply. That should do it.

by shanghai sam

Thanks for this even though it wasn't the full solution it was certainly a giant leap in the right direction. Thank you for your help.

This discussion is closed to new replies.