Thread
:
add text to a calculation
View Single Post
03-09-2024, 07:24 AM
Pablo2000
Windows 11
Office 2021
Novice
Join Date: Dec 2023
Posts: 25
add text to a calculation
Having googled i I was informed just to put the text into double quotes.
=B13-(B7/12) but
="("B13-(B7/12)")"
is there a better way?
I then tried ="(" & B13-(B7/12) & ")" but now I get
(244.728365) instead of £244.73
Pablo2000
View Public Profile
Find all posts by Pablo2000