Num Format Issue...??

[m0atz]

Not sure if this is a num format issue or not, but i'm pulling my hair out with this at the minute.

I have AQ2:BE17 filled with currency values (sales figures to 2 decimal places). These values are updated from a userform where I enter in sales figures. The userform updates the spreadsheet with a currency format, when i select the cells in the sheet they show as a currency format, but for some bizarre reason when i try and do a simple sum or average calculation, the results only include whole numbers, i.e. £35.00, £30.00 and not values such as £14.99 etc.

Am i going mad..??

 

[m0atz]

Actually - an update on this. I'm assuming it is a format issue of some kind, however all cells are formatted to currency, the userform puts the value in as format(value, "£#,##0.00") but its not taking any value updated from the userform (so ignore my comments about whole numbers etc)

 

[Andrew Poulsom]

The Format function returns text beacuase you are including the £ sign. So just transfer the value from the UserForm and format the cell as currency.

 

[m0atz]

Many thanks - that's sorted.