PDA

View Full Version : Quick Excel Question


Mark Beast
05-10-2006, 12:03 PM
is there no way to keep the 0 in front of a number if i'm tryping out invoice numbers?
for example 098424324 becomes 984243blablabla.

DJ SKILLZ
05-10-2006, 12:16 PM
Put ' in front of the zero's

Thats an apostrophe(sp) just in case

Geese Pants
05-10-2006, 12:19 PM
Select Row or Column, Go to Format -> Cells... , change category to text.
Or...........right click cell, go to format Cells.
It'll pretty much leave anything you type in a cell as is..............

Mark Beast
05-10-2006, 12:21 PM
thx. its cool, i already sent it to my boss. he's cool with it. thx for the replies though, i appreciate it.