Excel help, easy but important

**Andre** · 10-24-2006, 07:08 PM

Right click in the cell, choose format cell, under number tab select General. That shouls do it.

**Peaches** · 10-24-2006, 07:12 PM

That's odd. I just tried it every way I could and still get the 34335 even when the other numbers are showing right. Sorry

**the Shemp** · 10-24-2006, 07:15 PM

Originally posted by Peaches

That's odd. I just tried it every way I could and still get the 34335 even when the other numbers are showing right. Sorry

try changing the cell format to "text"

**mkx** · 10-24-2006, 07:16 PM

general doesn't change it

**mkx** · 10-24-2006, 07:17 PM

Originally posted by the Shemp

try changing the cell format to "text"

text just aligns everything to the left

**Peaches** · 10-24-2006, 07:20 PM

Yeah, for some reason it just doesn't like that number combination

**mkx** · 10-24-2006, 07:23 PM

Anyway to completely turn off formating? Or is there another program that doesn't do this?

**DjSap** · 10-24-2006, 07:24 PM

you can add ' in the beginning of the content as '01-94, that prevents the automatic formatting...

**the Shemp** · 10-24-2006, 07:24 PM

you have to make sure you have a blank cell to start off with.

**mkx** · 10-24-2006, 07:29 PM

Originally posted by DjSap

you can add ' in the beginning of the content as '01-94, that prevents the automatic formatting...

wooo hoo, thanks, that works, hope it solves the "'s from appearing in the html too, thats the next step though so will know soon

Comment