add text to a calculation

		Microsoft Office Forums > Microsoft Excel > Excel
add text to a calculation

03-09-2024, 08:23 AM

Pablo2000

Windows 11 add text to a calculation

Office 2021

Advanced Beginner

Join Date: Dec 2023

Posts: 73

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Legacy Text Field with Calculation is Rounding	Krhamm	Word Tables	8	12-19-2023 12:47 PM
Age Calculation	lawlaw	Word	8	06-07-2019 06:22 AM
Calculation to Pre poutlate Text	gdavey	Word VBA	4	08-19-2015 08:54 PM
Help with a sum calculation please.	ballst	Excel	4	06-04-2015 11:40 AM
Please help with age calculation!!!	Microsoft Idiot	Word	4	10-29-2012 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:32 PM.