- Excel 2003 - Negative values
- Posted by Zygy on April 27th, 2006
Is there a way of ALWAYS getting the figures of a negative value of currency
shown in read on a worksheet? If there is how do I arrange it?
- Posted by old man on April 27th, 2006
Check out 'format' for the cell or range.
If you mean however, that a new worksheet defaults to a specific format,
post to an excel specific ng for an answer. You are using OE for ng's so
just explore the other MS ng's
"Zygy" <jzw@bt.connect.com> wrote in message
news:QY2dnbnaeIiN9M3ZRVnyhQ@bt.com...
- Posted by old man on April 27th, 2006
PS MS news server
msnews.microsoft.com
"Zygy" <jzw@bt.connect.com> wrote in message
news:QY2dnbnaeIiN9M3ZRVnyhQ@bt.com...
- Posted by Zygy on April 27th, 2006
Thank you for the answer. But, I could not find an Excel specific ng. that
is why I posted here. Posting in Office ng did not produce any suggestions.
Do you know the address of Excel ng?
"old man" <dl@spoofmail.notme> wrote in message
news:Ev_3g.287$4I6.50@newsfe2-gui.ntli.net...
- Posted by Gordon on April 27th, 2006
Zygy wrote:
Can't do that, AFAIK - you have to format the cells for each sheet in a
workbook - the default is black.
- Posted by John Dean on April 27th, 2006
Zygy wrote:
You can create a worksheet or workbook template with whatever settings you
like. Then, whenever you want a new sheet, choose your custom template.
--
John Dean
Oxford
- Posted by Andy on April 27th, 2006
"John Dean" <john-dean@fraglineone.net> wrote in message
news:e2q472$jos$1@newsg2.svr.pol.co.uk...
Format; Cells; Number or Currency
from here you can select to have the negative figures in red.
works in '97 which I still use and 2003 should be backwardly compatible.
Andy
- Posted by Zygy on April 27th, 2006
Many thanks for the very to the point contribution. I selected the -£ in
read, but it did not work on the worksheet. You are probably better off with
Win.98 than I am with WinXPPro.
"Andy" <andy@dkw> wrote in message
news:4450bce7$0$8336$da0feed9@news.zen.co.uk...
- Posted by Gordon on April 27th, 2006
Zygy wrote:
the OPERATING system, (windows 98 or windows XP) has NO bearing on whet
Excel does.
- Posted by Beauregard T. Shagnasty on April 27th, 2006
Zygy wrote:
I typed "excel" into my newsreader and it found about fifty groups with
that word in the newsgroup name. Most are on the microsoft.public.excel
hierarchy.
Maybe:
microsoft.public.excel.misc
microsoft.public.excel.programming
microsoft.public.excel.worksheet.functions ...
--
-bts
-Warning: I brake for lawn deer
