Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2020, 03:13 AM
Jules90 Jules90 is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2019
Posts: 24
Jules90 is on a distinguished road
Question How to format negative values in red, right aligned but have £ sign to the left?

Hi,------please ignore message below - managed to work it out. Custom format code I required was £* #,##0.00_;[Red]£* (#,##0.00);-; Chose to put negative values in parenthesis



------------------------------

I’m trying to format a column of cells containing currency values – some negative which I want to show in red.

If I select the entire column and choose the ‘number’ format which shows negative values in red, it doesn’t include a currency symbol.

What I want to do if possible, is have the negative values automatically display in red when entered e.g. -45.00, but I also want to include a ‘£’ currency symbol aligned flush to the left of the column (with no preceding negative symbol) and with the figures aligned to the right.

Can anyone help me with this? I’m not sure how to enter this precise format in the custom ‘type’ box.

Thanks in advance

Last edited by Jules90; 09-18-2020 at 07:55 AM. Reason: Solved
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rtl text aligned right and ltr text aligned to left in one line - HOW? wordnew Word 10 09-06-2020 08:23 AM
button "clear format", etc; anchors, functions and properties of OpenType, negative width of symbol? tvan Other Software 1 07-18-2018 03:55 PM
How does Excel put values on negative degree(s)? JUSTIN CMM Excel 1 01-14-2016 12:41 AM
Using Left function to format a range USAOz Excel 4 09-10-2015 03:00 AM
Custom formatting to make negative numbers show w/o negative sign on charts todor PowerPoint 3 01-16-2013 03:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft