Cell content involving both trailing and leading zeros

Chris-Tillis

New Member
Joined
Apr 7, 2005
Messages
19
Hi all,

Hope everyone is well.

I was wondering if this seemingly impossible requirement is actually possible?!?

My girlfriends' a hairdresser, she uses products that have codes such as:

1/1
02/03
20/11

and so on.

I thought it might be nice to record these in a spreadsheet, however because they include both trailing and leading zeros, I'm stuffed as to know how she can enter them? I had hoped to lock a cell and place a forward stroke into it, and then have cells either side where she places the number.

So far the only way I can think of, is that she treats them as notes, i.e. characters/words.

Curious to know if anyone can think of a workaround!

Thanks,

Chris
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Gary's Student

Well-known Member
Joined
Aug 4, 2012
Messages
1,015
If the values are typed into cells, Excel may treat them as Dates. Enter values with a leading apostrophe (single quote) to avoid this.
 

Chris-Tillis

New Member
Joined
Apr 7, 2005
Messages
19
Thanks for your responded, very much appreciated. I was aware of the workaround using an apostrophe, but I just wondered if there was a way of keeping it numerical, despite the numbers changing from have a leading to a trailing zero. It's really got me head scratching!?!

Cheers, Chris
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,173
Members
417,129
Latest member
geekzilla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top