Excel question

Mr_Skint_2

Cerbera wrote:

Great link Mr Skint :T
You don't have anymore for Word, Powerpoint, etc by any chance?

BTW brilliant avatar :eek:

http://www.bcschools.net/staff/WordHelp.htm

Nile

scheming_gypsy wrote:

i'm no expert on Excel but doesn't #### usually mean that the cell isn't wide enough to fit the number?

I thought so too. Try double clicking on the right edge of the cell/columm to adjust the column width to automatically fit.........and this should reveal the hidden digits behind the ####.;)

Cerbera_2

Mr_Skint wrote:

http://www.bcschools.net/staff/WordHelp.htm

:T :T :T Thanks and thanks for the lightspeed reply

Mr_Skint_2

Cerbera wrote:

:T :T :T Thanks and thanks for the lightspeed reply

No worries, I like that pumpkin :eek:

Mr_Skint_2

## Im quite sure is an incorrect formatted value or inserted formulae..

feival

shopbot wrote:

Okay a solution of sorts:
Find a blank cell. Paste the number 1 into it. Copy this cell. Highlight the cells you need to convert from text to number and then right click for Paste Special and then select multiply. Bingo!

This can't be the quickest way though......

and now the converted cells show as ## :mad:

This is the way I do it - I know of no quicker or better way to convert text to numbers.