SPREADSHEETS

[lizz]

Hi plz can anyone tell me what to do to enable the number 0 to show in a
spreadsheet, If i type 3201 the 0 will show and print but anything with the 0
for ex 0123 the 0 is missing
Many Thanks

 

[Gordon]

Hi plz can anyone tell me what to do to enable the number 0 to show in a
spreadsheet, If i type 3201 the 0 will show and print but anything with
the 0
for ex 0123 the 0 is missing
Many Thanks

Create a Custom Format of 0###

However, please note that any spreadsheet that you may have is NOT part of
Windows - you will get better answers to your spreadsheet questions if you
post in the appropriate spreadsheet group.

HTH

 

[db ´¯`·.. >]

'0123

--

<)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><)))º>

..

 

[Blattus Slafaly £ ¥ ‰ :)]

Hi plz can anyone tell me what to do to enable the number 0 to show in a
spreadsheet, If i type 3201 the 0 will show and print but anything with the 0
for ex 0123 the 0 is missing
Many Thanks

Just change the number format of the cell or group of cells. You can
specify leading zeros or currency format or number format, etc.