How do I keep the 0 at the beginning of a number, ex. 090?

S

Sandy Mann

Pre-format the cells as text or precede it with an apostrophe

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HI, I want to 5-9 as age group but it comes as 05 sept date forma 0
correct to the nearest half 1
how can i determine number of weeks between 2 dates 0
why does excel change my numbers? 3
ERASE THE "NUMBER 1" IN THE MIDDLE OF SPREADSHEET 0
how do i format an excel cell for stopwatch times mm:ss? 0
what formula do you use to get the name of a tab? 1
O.T. What's happening in the Newsgroups? 5

Top