Is there a way to display zero as a leading number, ie. 0567
P Peo Sjoblom May 16, 2008 #2 You can use a custom format but it means you have to have a fixed sets of digits to display 0000 as an example would return 0567 but it would also return 1234 and not 01234 -- Regards, Peo Sjoblom
You can use a custom format but it means you have to have a fixed sets of digits to display 0000 as an example would return 0567 but it would also return 1234 and not 01234 -- Regards, Peo Sjoblom
C Cimjet May 16, 2008 #3 Format the cell as text before you enter your data and precede the data with an apostrophe. ex. '0543 the apostrophe will not show in the cell. Regards Cimjet
Format the cell as text before you enter your data and precede the data with an apostrophe. ex. '0543 the apostrophe will not show in the cell. Regards Cimjet
