View Single Post
 
Old 03-09-2024, 07:24 AM
Pablo2000 Pablo2000 is offline Windows 11 Office 2021
Novice
 
Join Date: Dec 2023
Posts: 25
Pablo2000 is on a distinguished road
Default 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
Reply With Quote