Microsoft Office Forums - View Single Post - add text to a calculation

Thread: add text to a calculation

View Single Post

Old

03-09-2024, 08:23 AM

Pablo2000

Pablo2000 is offline

Pablo2000 uses Windows 11

Windows 11 Pablo2000 uses Office 2021

Pablo2000 uses Office 2021

Office 2021

Advanced Beginner

The original poster

Join Date: Dec 2023

Posts: 73

Pablo2000 is on a distinguished road

Default

I have a cell that gives a calculation of £244.73.
I get

Quote:

(244.728365) instead of £244.73

That would sugest this is supposed to be currency and by adding the text it has turned it into a number instead.

Reply With Quote