how to get excel cell "01" value?

hi. i want to get a cell that can have a 0 before some other numbers. how can i do this? the cell looks like "01" but the value is only 1. but i want to get "01". the cell is formated. is there a way to do this?
 

sahil_raina_91

Active Member
hi. i want to get a cell that can have a 0 before some other numbers. how can i do this? the cell looks like "01" but the value is only 1. but i want to get "01". the cell is formated. is there a way to do this?

Could you explain with an example, along with screenshots ?
 
1612875777699.png

as you can see, the cell value is 1. but i want to get 001. is there a easy way to do this? or is the only way calculating it after getting the value?
 
Top