Share this content

O/Topic - excel formatting

Didn't find your answer?

have downloaded  a mass of dividend data

however column with the income shown as  £data - shown as [£ 123.45]  - does not Sum - only counts !  So how do i reformat

tried  [ format cells/number+currency] to no avail

thanks sure its simples...

Replies (2)

Please login or register to join the discussion.

By emanresu
13th Sep 2019 11:33

Highlight the column and use REPLACE to delete/change non-numeric characters.

Thanks (2)
By paul.benny
13th Sep 2019 15:12

Or use VALUE function if you have numbers stored as text

Thanks (2)
Share this content