Hi
I would like to enter the following number in a cell: 09 -5166, but it
appears as 1193127. Which format do I select to acheive this.
Many Thanks
Gunjani
Hi
I would like to enter the following number in a cell: 09 -5166, but it
appears as 1193127. Which format do I select to acheive this.
Many Thanks
Gunjani
Use text format or precede with an apostrophe '
--
Regards,
Peo Sjoblom
"Gunjani" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I would like to enter the following number in a cell: 09 -5166, but it
> appears as 1193127. Which format do I select to acheive this.
>
> Many Thanks
>
> Gunjani
Hi Gunjani,
Excel thinks that you are entering a date and so enters the date September 1
in the year 5166. Try placing an apostrophe before entering the 'number' or
formatting the cell as text before any entry is made.
HTH
Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk
"Gunjani" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I would like to enter the following number in a cell: 09 -5166, but it
> appears as 1193127. Which format do I select to acheive this.
>
> Many Thanks
>
> Gunjani
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks