Tech Support Guy banner
Cancel

Solved: Need help formatting Excel spreadsheet

1307 Views 2 Replies 2 Participants Last post by  smeegle, 
S
I am trying to enter a whole number that looks like this "123" into a cell and have it look like this "00123". I've even tried to custom format it and I can't get it to work. Please help:)
Save
Like
Status
Not open for further replies.
1 - 1 of 3 Posts
O
Hello smeegle, select the cells that you want to format and the on the main menu select Format>Cells>Number>Custom
and type in the box
00000
this will give you the format that you have shown.
Save
Like
1 - 1 of 3 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top