formatting cell with $

G

graham feeley

Hi am running 95 and using excel for printing a banking sheet which was
setup by a previous employee.
it will take amounts up to 99 thousand but with amounts over that it
produces numbers without the $ sign in front.
I need to have the $ in front with large amounts.
Any help will be appreciative
I have tried different formats with different results, but not the one I
wish to have.
Regards
Graham
 
A

Andrew

Graham,

Try widening the cells, then entering the amount.

After that it might be possible to format as you like.

You might also try entering $#,##0.00 in the Custom format part of th
Format dialog box. (Right click and then select the Number tag, it'
located at the bottom)

Other than that, keep trying. Old and New versions of Excel seem t
differ regarding formatting, perhaps someone else knows a bette
solution.

if you do find a way, please share it with the rest of us
 
N

Nick Hodge

Graham

The only thing I can think of is that the format has a conditional aspect
via Format>Cells...>Number>Custom. It will look something like

[<99000]$0.00 ;[>99000]0.00;General

I presume this workbook has no user defined functions or code?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
G

graham feeley

Thanks guys for the reply.
I will try tonight working with a new document just in case the old custom
formats are not cancelling out.
Will let you know in time
Regards
Graham
 
Top