Question

does anyone know how to use excel

Answer 1

what are you trying to do?

Answer 2

yes what do u need help on

Answer 3

i have edited a worksheet, for some reason there is a number symbol where a number should be and it is not allowing me to format it

Answer 4

or fix it

Answer 5

want to attach it?

Answer 6

not that i would really know what to do. i assume you have selected the cell and tried "format"

Answer 7

yes it just goes back to a # instead of 27

Answer 8

which cell?

Answer 9

i see 27 in d -15

Answer 10

all the ones that have # should be a number. lets start with B7 it is suppose to be 109 and instead it is ##

Answer 11

oooooooh i see

Answer 12

yes D15 should be 27

Answer 13

not in the view i have, i see the numbers

Answer 14

it is probably doing that in your view because your columns are not wide enough
make them wider

Answer 15

ok now im more confused, the file i have shows #'s and when I print it, it shows #'s

Answer 16

you can either select the column and hit "auto format" or "optimal width" whatever it is called
or just drag the column to make it wider

Answer 17

in my view i see the numbers, because somehow it is wider in my format than in yours. if the numbers don't fit in the columns you will see # or ##

Answer 18

thank you so very much i have been sitting here forever trying to figure out how to fix this thank you soooo much

Answer 19

did it work??

Answer 20

yes it did
THANK YOU!!!

Answer 21

your quite welcome
these programs get very frustrating when you see something for the first time

Answer 22

I have never used excel it is a new class that i started yesterday