Change Value Format

[CARBOB]

How do I change the format of the values in row 3, the ones beginning with zero, so the formulas will work?

CASH3 EVE 100 COMBO SUMS WITH HORS.xlsx
	AL	AM	AN	AO
1	#VALUE!	#VALUE!	A1D	A2D
2	#VALUE!	#VALUE!	1	2
3	090	099	100	101
4	#VALUE!	#VALUE!	AOEELLLOOO	AOEOLLLOOO
DBLS

 

[XLXRider]

It looks as though you've entered the 090 and 099 as text in order to get the leading zeros (or is it zeroes?).

Use a custom number format: Format, Cells, Custom. Enter 000 as your number format. Now, when you enter 9 in the cell it will display as 009, 26 will display as 026, and so on... and Excel will treat it as a number instead of text.

Should solve your problem!

Regards,
XLXRider

 

[CARBOB]

Any way you wish to spell it, I understand and thank you very much!!!!

It looks as though you've entered the 090 and 099 as text in order to get the leading zeros (or is it zeroes?).

Use a custom number format: Format, Cells, Custom. Enter 000 as your number format. Now, when you enter 9 in the cell it will display as 009, 26 will display as 026, and so on... and Excel will treat it as a number instead of text.

Should solve your problem!

Regards,
XLXRider