How do you insert the sequence "10-8-6" onto a worksheet without it
automatically translating the format into the date 10/08/2006?
How do you insert the sequence "10-8-6" onto a worksheet without it
automatically translating the format into the date 10/08/2006?
Format the cell as Text before entering the data.
--
Ian
--
"Vidz" <[email protected]> wrote in message
news:[email protected]...
> How do you insert the sequence "10-8-6" onto a worksheet without it
> automatically translating the format into the date 10/08/2006?
Thanks Ian
"Ian" wrote:
> Format the cell as Text before entering the data.
>
> --
> Ian
> --
> "Vidz" <[email protected]> wrote in message
> news:[email protected]...
> > How do you insert the sequence "10-8-6" onto a worksheet without it
> > automatically translating the format into the date 10/08/2006?
>
>
>
Hi
Or, place a single quote ' before your entry. It won't show up in the cell,
only in the formula bar, and will tell Excel to treat the value as text.
Regards
Roger Govier
Vidz wrote:
> How do you insert the sequence "10-8-6" onto a worksheet without it
> automatically translating the format into the date 10/08/2006?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks