What does an apostrophe used before a number indicate in the header column of a financial spreadsheet?

Question

What does an apostrophe used before a number indicate in the header column of a financial spreadsheet?

Becca M-Cheevers 0

Hi there, Can anyone tell me what the £'000 column header makes the figures below it?....What figure in £ is 416?

1 answer

Your answer

Answer 1

When a column header shows £'000, it means that all numbers in that column are expressed in thousands of pounds. Effectively, you must multiply the shown number by 1,000 to get the actual pound value.

So if you see 416 under a £'000 heading, the actual amount is £416,000.

It's just shorthand to avoid writing lots of zeros.

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Share via

What does an apostrophe used before a number indicate in the header column of a financial spreadsheet?

1 answer

Your answer