FORMATTING - Annoying Problem

[Pat]

I converted my #'s to currency and I selected to show $
sign. However, the dollar sign is not displayed. The
only way I can get it to be displayed is if I go to each
cell and hit enter. Does anyone know why this is. I am
using excel 2002. I never had this problem with any other
version.

Note: the column width is ample enough. I have used excel
for many years and I never came across this.

 

[DNF Karran]

Excel is probably reading the numbers as text and will not change the
to numbers by just altering the format- In addition you will have to d
some calculation on the cells to force the change.

eg if your data is in column a then :

a b
5.00 =--A1
10.00 =--A2

And paste special values from col B over col A.

Dunca

 

[Gord Dibben]

Pat

Numbers are probably seen by Excel as text.

Copy and empty cell(formatted as general) then select your range of "numbers"
and Paste Special(in place)>Add>OK>Esc.

Gord Dibben Excel MVP