Is there any way to format this other than formatting as text
I'd be grateful if anyone has an answer
--
Carys
Is there any way to format this other than formatting as text
I'd be grateful if anyone has an answer
--
Carys
Carys wrote:
> Is there any way to format this other than formatting as text
>
> I'd be grateful if anyone has an answer
> --
> Carys
Hi Carys
Select your cell range.
Format > Cells. Under Category, click Custom.
In the Type field, enter 0000. Click OK
Regards
Steve
Use a custom format of: 0000
??????
Carys wrote:
>
> Is there any way to format this other than formatting as text
>
> I'd be grateful if anyone has an answer
> --
> Carys
--
Dave Peterson
Thanks Steve
--
Carys
"[email protected]" wrote:
>
> Carys wrote:
>
> > Is there any way to format this other than formatting as text
> >
> > I'd be grateful if anyone has an answer
> > --
> > Carys
>
> Hi Carys
>
> Select your cell range.
>
> Format > Cells. Under Category, click Custom.
>
> In the Type field, enter 0000. Click OK
>
> Regards
>
> Steve
>
>
Thanks Dave.
Works a treat
--
Carys
"Dave Peterson" wrote:
> Use a custom format of: 0000
> ??????
>
> Carys wrote:
> >
> > Is there any way to format this other than formatting as text
> >
> > I'd be grateful if anyone has an answer
> > --
> > Carys
>
> --
>
> Dave Peterson
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks