Why when I type in 5000 in Excel does only the number 5 show up? I have the format set to general.
B ballhawk May 27, 2006 #1 Why when I type in 5000 in Excel does only the number 5 show up? I have the format set to general.
G Gord Dibben May 28, 2006 #2 Go to Tools>Options>Edit and uncheck "fixed decimal places" Gord Dibben MS Excel MVP
