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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
If the values are typed into cells, Excel may treat them as Dates. Enter values with a leading apostrophe (single quote) to avoid this.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,216,130
Messages
6,129,058
Members
449,484
Latest member
khairianr

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
Back
Top